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

---

Why not simply update the string to uppercase?
Then you have no problem with the case