Viewing 2 posts - 1 through 2 (of 2 total)
Check out REPLICATE to pad with leading zeros:
select replicate('0', N - datalength(cast (X as varchar (N)))) +
cast (X as varchar (N))
from, YYY
N = length of string
X = name of...
October 24, 2003 at 7:37 am
#479463
We just spent most of yesterday on this exact same problem. Try re-booting or stopping and re-starting all the services. That fixed our problem.
July 29, 2003 at 9:38 am
#467520