How to replace a an invalid character(as per business rules) in the column data using a query? For example, in our application, the following characters are valid.
'[^-\^_<>`~{} :[",#$%&!?;+0-9a-zA-Z@/*().]'
I want to replace all the characters, which don't belong to this character set, with empty string.
How is this possible?
Thanks in Advance,
Manohar
'[^-\^_<>`~{} :[",#$%&!?;+0-9a-zA-Z@/*().]'
I want to replace all the characters, which don't belong to this character set, with empty string.
How is this possible?
Thanks in Advance,
Manohar