Monday, February 13, 2017

Translate Special Characters using REGEXP_REPLACE


Translate Special Characters using REGEXP_REPLACE

select * from ar.hz_parties
where upper(trim(REGEXP_REPLACE(party_name ,'[^[:alnum:]'' '']', NULL)))  = upper(trim(REGEXP_REPLACE(:party_name,'[^[:alnum:]'' '']', NULL)));