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