Hi Terry,

I asked a similar question about a week ago (g) only I wanted the PADR() function.

According to Mike Levy, there's no intrinsic function in TSQL that matches the padding functions in VFP. His suggestion was to write UDFs for them (and a good suggestion -- I'm doing those -- thanx Mike).

Bob Archer suggested to use the CAST function to accomplish this (and it worked for the particular case I asked about -- thanx Bob).

Thread # 514206, message # 514255 if you'd like further info.

HTH.

>I have a varchar field that needs padding to allow proper ordering and checking for duplicates.
>
>Is there a command to pad zeroes onto a string?
>
>TIA