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')