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