> `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 using REGEXP_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>
