Is is possible to use replace along with regular expression to remove any and all punctuation from a field?
If so how?
I have tried: SELECT replace ('Brian\'s Co, INC.', 'Y*([.]',''),SUBSTRING('XY1234Z', 'Y*([0-9]{1,3})');
The second field substring works with out a problem the replace does not! How man I make that work?