REGEXP_REPLACE question... weird results
10259May 29 2008 — edited May 30 2008here is my query...
SELECT
':'
|| regexp_replace( middlename, '[^[:alnum:]]', '')
|| ':' ack,
middlename
FROM zz_student_sarmaster s
WHERE REGEXP_LIKE (middlename, '[^[:alnum:]]')
The results I get are similar to this:
ACK MIDDLENAME
==== ===========
:WN: W
:MN: M
What I'm trying to do is clean up the data... I know the data is coming from the mainframe and I suspect there is some extraneous characters being stored... hence the "where" clause... however, when I do my REGEXP_REPLACE... I get that "N" character... any ideas where it comes from????