True. I forgot that proper() function works for multiple words in a string.

>Sergey this will only work if the field has only one word for more words then only the first one will be caps.
>
>>>Hi,
>>>
>>>Does anyone know if there are a similar function to the proper() function in VFP on SQL Server 2000?
>>>
>>>I need to convert my data from uppercase ?
>>>
>>>
>>
>>No there isn't but you can build one

UPPER(LEFT(last_name,1)) + LOWER(SUBSTRING(last_name,2,1024))