>i tried to upsize my app to sql server. at the end many views have not been converted with the upsize wizard due to the alltrim command.
>what can i do ?
You can recode your view to do LTRIM(RTRIM()) in SQL Server if you absolutely need it. See the following link, which I've found to be very helpful as I've transitioned to SQL Server...
http://fox.wikis.com/wc.dll?Wiki~VFPSQL-TSQL-Mapping
Del