<div>
Messy, but how about:<br />
<br />
Replace( Repalce( Replace( MyString,'a','' ),'b','' ),'c','' )<br />
<br />
Regards<br />
<br />
Chedgey
</div>


Messy, but how about:

Replace( Repalce( Replace( MyString,'a','' ),'b','' ),'c','' )

Regards

Chedgey

<div>
Mmmmh, thanks chedgey. I did think about doing it this way but was hoping there was a better way :(<br />
<br />
Do you think this is the only way it can be done?<br />
<br />
Will hold out to see if anyone else has any other suggestions.
</div>


Mmmmh, thanks chedgey. I did think about doing it this way but was hoping there was a better way :(

Do you think this is the only way it can be done?

Will hold out to see if anyone else has any other suggestions.

<div>
Try TRANSLATE:<br />
<br />
Select translate('AaBbCcUYTUYTUYT<wbr />','~abc','<wbr />~') From Dual;<br />
<br />
TRANSLATE('A<br />
------------<br />
ABCUYTUYTUYT<br />

</div>


Try TRANSLATE:

Select translate('AaBbCcUYTUYTUYT','~abc','~') From Dual;

TRANSLATE('A
------------
ABCUYTUYTUYT


<div>
<br />
PS: Note the required '~' character (or any other you want).<br />
<br />

</div>



PS: Note the required '~' character (or any other you want).



<div>
Thanks Mike but I'm being told that TRANSLATE is not a recognised function name. I'm using MSSQl
</div>


Thanks Mike but I'm being told that TRANSLATE is not a recognised function name. I'm using MSSQl

<div>
<div class="content wysiwyg-content">
Hi <br />
<br />
I want to remove multiple characters (that are not necessary sequential) in a string.<br />
<br />
To remove the character 'a' from a string I use the following:<br />
<br />
REPLACE(mystring, 'a', '')<br />
<br />
But if I want to remove all 'a's 'b's and 'c's how do I do it?<br />
The following does not work but displays the logic I need:<br />
<br />
REPLACE(mystring, 'a' | 'b' | 'c', '') <br />
<br />
Fast reponse greatly appreciated!
</div>
</div>


Hi 

I want to remove multiple characters (that are not necessary sequential) in a string.

To remove the character 'a' from a string I use the following:

REPLACE(mystring, 'a', '')

But if I want to remove all 'a's 'b's and 'c's how do I do it?
The following does not work but displays the logic I need:

REPLACE(mystring, 'a' | 'b' | 'c', '') 

Fast reponse greatly appreciated!

SQL REPLACE for multiple characters

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.