Hi Kenneth in SQL Server 2000 there aren't a similar Function you only have UPPER and LOWER functions no PROPER.

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