>i have just upsized to sqlserver. but all vues have not been upsized cause of some vfp functions that sqlserver doesn't know such as alltrim().
>so i want to creat a code that loop into the database and replace all unrecognized functions with the right functions.
>how can i do it ?
Are you saying you had alltrim in your index expressions? I'm not sure how exactly would you identify all the functions which are valid for VFP and not valid for SQL Server. I think it should be a manual process once you get a list of all index expressions with functions.
If it's not broken, fix it until it is.
My Blog