>>>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.

Thanks Edward. I actually misread the question, I think now he was talking about where clause in the views. There are ways to get view definitions (perhaps the simplest using GENDBC utility) and then I think someone should manually review the list.

Of course, it could be automated as well, but at this moment I don't want to think more on the problem.