>< 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"
He-he, I realized it before trying... Now the problem is to insert space before and after each symbol. Can you do it in one command or I should use a loop?
I'm writing this code right code and this is a part of the code: (though I may eliminate some symbols, which would not used in filter() anyway):
#define SYMBOLS ':;,./\<>+=-{}[]()!#*?'
If it's not broken, fix it until it is.
My Blog