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

Einar,

I found this message accidentally Re: IIF in SqlServer and Overview for SQL server Functions Thread #803735 Message #804034

Also in SQL Server Standard magazine for March/April 2008 there is an interesting article about UDFs by Wayne Fillis.