gipasoft

PadLeft with '0' in SQL

Nov 15th, 2016
267
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.07 KB | None | 0 0
  1. SELECT REPLACE(STR(id, 4), SPACE(1), '0') AS [padded_id]
  2. FROM tableA
Advertisement
Add Comment
Please, Sign In to add comment