Viewing 2 posts - 1 through 2 (of 2 total)
Wouldn't it be better to use something like this:
SELECT RIGHT(REPLACE(STR(@NUM),' ','0'),5)
Reference:
http://stackoverflow.com/a/779142/245764
July 22, 2015 at 1:24 am
#1814018
I guess the output will be similar if we'd do a cross join.
September 26, 2012 at 1:12 am
#1542232