Question
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.

Example

%Lis&ten  - Listen

10
0 4 161 2

Replies

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 :)