Hi,

How can we extract only alpha numeric characters from a string in DB2??

My input string is mixed with Special characters:
ABCdef@^TM12343"":}}YES
Expected Ouput :
ABCdef12343 YES
(Only to extract Alpha numeric characters excluding the special characters)

Note : Set of Special characters is not known exactly to use translate /replace function.

Is it possible to use NOT function in inside translate/replace?
(Like translate those characters to '' which does not belong to [A-Za-z0-9])

Please help me in this .

Thanks in advance.

You should have posted the question in DB2 forum; its functions might be different from Oracle ones.