Re: How to remove a set of characters in text-columns ?

Am 01.07.2011 04:17, schrieb Tim Landscheidt:
> besides the regexp_replace() solution mentioned by Charlie
> and Steve, you can also use TRANSLATE():
>
> | tim=# SELECT TRANSLATE('a{b''c"d!f', '{}()''",;.:!', '');

nice, 2 solutions for 1 problem.   :)
my replace...replace... was a wee bit tedious   ;)

thanks a lot to you, Charlie and Steve   :)


regards
Andreas