>>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.
SQL-Server creates either index on a column (field) or on few columns together, i.e. no functions in index expressions. One may imitate functions by creating index on computed column that is defined by using functions, but it would be a rarity.
Edward Pikman
Independent Consultant