sqlstringvarchartrim

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

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?

Solution

  • 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