You should review all your views that use ALLTRIM() to make sure that ALLTRIM() s necessary there. In WHERE clause ALLTRIM() in most cases can be replaced with '==' operator. You can post View SQL where you think ALLTRIM() is neccessary.
Even if view has been upsized, it doesn't mean it'll work correctly in SQL Server unless you're using SET ANSI ON. See
http://www.berezniker.com/display/VFP/String+comparison+in+VFP for more info.
>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 ?
>is there another upsize utility that can help ?
>is is possible to edit the wizard procedure and re-code it ?
--sb--