var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Extracting Only Alphanumeric Charcater in DB2
How can we extract only alpha numeric characters from a string in DB2??
My input string is mixed with Special characters:
Expected Ouput :
(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.