Getting 0 padded values in the columns.
Hi All,
I have a requirement to convert a integer to string and display it in
Sql server with fixed length say 3 chars. (in c, we wud use %03d in
printf)
If the number is small say, 9 then it has to be displayed as 009,
56 -> 056, 897-> 897, 6786 -> xxx
Checked through STR and CAST functions, couldn't find any relevant
paramters.
if you have any ideas, please mail me.
Thanks & Regards,
Chandra Mohan