SQL Server: How do you remove punctuation from a field? – oraerr.com - strip all punctuation t-sql code

Category

Stripping Punctuation - Microsoft SQL Server strip all punctuation t-sql code


CREATE TABLE Punctuation (Symbol VARCHAR(1) NOT NULL) INSERT function in SQL to remove all the punctuation symbols from an input string. .. ( Not trying to be snarky, if I had the code ready, I'd share it but this is.

You can do the same thing using the REPLACE function directly over the so that you don't have to re do this function every time on the query. Good Luck:).. visit www.sqlsaga.com for more t-sql code snippets and BI.

Hi all, Is it possible to remove all punction from a given string? I.E. I'm I have done something similar using PATINDEX and a while loop, try this code. There was an article on SQL Server Central about a very similar topic.