Hi,
I would like to replace default value 'ABC' when 'Invoice_desc' column having special characters like below
4835-079 GUIMARÃES
Yenilevent/BeÅŸiktaÅŸ
I wrote below query to replace the column value but its not working as expected
SELECT CASE WHEN REGEXP_LIKE (invoice_desc, '[^[:alnum:] &!"$%^()_+=*{};:@#~,<.>?\|-]') THEN 'ABC' ELSE invoice_desc
END AS invoice_desc,invoice_num
FROM ap_invoices_all
WHERE 1=1
--and REGEXP_LIKE (invoice_desc, '[^[:alnum:] &!"$%^()_+=*{};:@#~,<.>/?\|]');
Can you please help me on this issue.
Thanks