>vfp upsize wizard doesn't convert alltrim fonction to sqlserver. to correct that i recoded my view by changing ALLTRIM by RTRIM.
>other functions have the same problems such as VAL() and ISNULL().
>
>what function can i use to replace these functions in order to be recognise by the upsize wizard ?

You can replace VAL() with CAST() and ISNULL() with 'IS NULL' operator.