< SNIP >
>>I've tried to run it on the filtered index on Lender table and got a message: code is not unique and must be qualified.
>>
>>Here is lcWhere expression: where CODE#PARENTCODE.OR.PCOFLAG="P"
>>Obviously, I want to insert a. before code, parentcode, pcoflag. How can I do this string manipulation?
>>
>>BTW, just thought, that I should use at least two letters to aliases, but it doesn't change my question how to perform this string modification?
>
>Ok, I have an idea about last problem. Just do a loop on each field and perform strtran(str, fieldname, "a."+fieldname).
It's not gonna work. You'll get
a.CODE#PARENTa.CODE.OR.a.PCOFLAG="P"
--sb--