You can try the REPLICATE function. Here is a sample where in this case the pad character is '0' and the overall length is 5.

SET @nextjobid = REPLICATE('0',5 - LEN(LTRIM(@nextjobid))) + LTRIM(@nextjobid)

HTH
John

>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