Look at that other FAQ with a similar, although more general topic: How to strip several different characters from a string? Mark's first sample should do the trick. |
Regular Expressions are useful in search criteria but not really applicable to string manipulation. You can try using the REPLACE() function, as in:
And yes, there are 3 nested calls to this function, 1 per character to be replaced. |