How can I trim certain characters from a string in sql?

Question

I would like to trim all special characters from a string in SQL. I've seen a bunch of people who use substring methods to remove a certain amount of characters, but in this case the length on each side of the string is unknown.

Anyone know how to do this?

Thanks,
Matt

Answer 1

use replace function will help you

i mean to say when you want to remove special char replace this space' ' by using replace function

more about replace : http://technet.microsoft.com/en-us/library/ms186862.aspx

Answer 2

In MS SQL, this will remove all plus signs:

SELECT REPLACE(theField, '+', '') FROM theTable

Is that the sort of thing you need?