Kenneth,
As Alexandre mentioned, there is no PROPER() function in SQL Server. You could create a remote view or updatable SPT cursor and then use REPLACE ALL to update the SQL Server data using VFP's string commands.
HTH
>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
Daniel