|
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? |
