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.
Example
%Lis&ten - Listen