Mohamed Ashik · Jun 20, 2020

Removing special characters from different lengths of strings in Intersystems cache sql

I have a set of strings that contains special characters. Im trying to write a sql query to remove all the special characters in the string. Im using Intersystems cache sql.


%Lis&ten  - Listen

0 4 161 2


This helps alot, Thank you Dhinupa.

characters are random, it can be any of the special characters. but yeah i was able to use this directly in my query. Thank you :)