>>Hi everyone,
>>
>>I have this problem: my application returns a string which is form of where condition, e.g.
>>
>>"SiteMstr.ccode='01' and inslist(TranMstr.Lender,code1, code2) and etc."
>>
>>We're going to implement Data Warehouse algorithm, and therefore, I want to exclude all references to Table aliases from this string. The tables are limited to just three (may be four):
>>SiteMstr
>>TranMstr
>>PropMstr
>>
>>My problem is that I don't know, how did I spell it, e.g. it could be:
>>Sitemstr
>>SITEMSTR
>>SiteMStr
>>etc.
>>
>>Of course, since it's my application, I can go through the form code, and use just one name convention everywhere, like "SiteMstr", but I'd like to know, perhaps there is more elegant solution.
>>
>>I guess, RegExp should help me here, but I don't know, how to use it in this case.
>>
>>Thanks a lot in advance.
>
>Nadya,
>What does case differ ? IOW how would you use it ? In something like atc() or find&replace ?
>In a string operation you could combine atc() and stuff().
>Cetin
I'd like the analogue of strtran but with case insentitive. Anyway, I've just checked the form code and found, that I always use the same convention: SiteMstr, PropMstr, TranMstr, so this is not a problem.
If it's not broken, fix it until it is.
My Blog