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?