Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Replace
- ===
- REPLACE('12-345-67', '-', '')
- Add leading zeros (left pad)
- ===
- Right("000000" + Str([EmployeeID]),6)
- Pretty print hard disk sizes
- ===
- IF
- LEN(STR([Size])) > 9 THEN LEFT(STR([Size]), 1) + "." + MID(STR([Size]), 2, 1) + " TB"
- ELSEIF LEN(STR([Size])) > 8 THEN LEFT(STR([Size]), 3) + "." + MID(STR([Size]), 2, 1) + " GB"
- ELSEIF LEN(STR([Size])) > 7 THEN LEFT(STR([Size]), 2) + "." + MID(STR([Size]), 2, 1) + " GB"
- ELSEIF LEN(STR([Size])) > 6 THEN LEFT(STR([Size]), 1) + "." + MID(STR([Size]), 2, 1) + " GB"
- ELSEIF LEN(STR([Size])) > 5 THEN LEFT(STR([Size]), 3) + "." + MID(STR([Size]), 2, 1) + " MB"
- ELSEIF LEN(STR([Size])) > 4 THEN LEFT(STR([Size]), 2) + "." + MID(STR([Size]), 2, 1) + " MB"
- ELSEIF LEN(STR([Size])) > 3 THEN LEFT(STR([Size]), 1) + "." + MID(STR([Size]), 2, 1) + " MB"
- END
Advertisement
Add Comment
Please, Sign In to add comment