As a part of validating a requirement I need to remove special characters from a string .so could you please suggest any function to remove special characters from a string or to replace the special characters in a string with blanks?
VBN MGH & CO VBN MGH CO
There are two functions oreplace and regexp_replace which does the above requirement . But both of these functions are not supported in Teradata v.13.
Kindly help me in solving this issue
if still on td 13, then position alongwith substr function can be used. position to identify position of special character in string and substr to dissect and concatanate strings.