> `select upper(x) from test`
I know about the UPPER() and LOWER() functions - I don't want them!
> If you want to do something else, please describe the actual thing you
> want to do. Not "how", but "what".
I have described it - I want to do the *_same_* thing as UPPER() does using REGEXP_REPLACE().
In the duplicate thread (apologies to the list for that - my bad!), I wrote:
====================
> I want to index on a REGEXP_REPLACE() - I thought using lower -> upper would be a good test.
> I could always have used another REGEXP_REPLACE() for my testing, but I then became "obsessed" with the idea of
usingREGEXP_REPLACE() as a substitute for UPPER() - kind of an obfuscated code competition with myself! :-)
========================
So, I have no actual *_need_* for this, other than a desire to learn and understand what's going on and why.
> Maybe you need to look at `regexp_split_to_array` or
> `regexp_split_to_table`?
I'm pretty sure that I have a good understanding of these. I thought I understood REGEXP_REPLACE(), but obviously not.
Thanks for any further input.
E.
> Dakkar - <Mobilis in mobile>