Tracy,

He he, BOL is your friend :-D

MartinJ

>Thanks so much Martin! That works.
>
>
>>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')