>>>The link below points to Igor Nikiforov 's library of T-SQL udfs that contains manty VFP like functions including PADLEFT().
>>>
>>>http://www.levelextreme.com/Report.aspx?Session=30366A622B5A36764855493D20456B71634147563934754E576D414B7568687676536B55703445414565636A4B
>>>
>>>I have used it for a number of functions with good results
>>
>>Awesome thanks for the link.
>
>Keep in mind that using UDF can severely affect query performance.

Thanks Sergey