Hi Tracy,
no, but you can use other functions:

REPLICATE(' ',nLength-LEN(RTRIM(LTRIM(expression))))+RTRIM(LTRIM(expression))


SELECT * FROM mytable ORDER BY mytable.myfield, REPLICATE('0',15-LEN(RTRIM(LTRIM(mytable.myfield2))))+RTRIM(LTRIM(mytable.myfield2))

MartinJ

>Nevermind, LPAD.
>
>
>Anyone know the equivalent to PADL() in SQL?
>
>E.g.:
>
>SELECT * FROM mytable ORDER BY mytable.myfield, PADL(mytable.myfield2,15,'0')