Special Character Removal

Question

Post reply

Special Character Removal

krypto69

SSChampion

Points: 13604
More actions
February 2, 2016 at 10:47 am

#399663

HI,
Does anyone have a way to search all the columns in a table for special characters (non allowed)?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Luis Cazares SSC Guru Points: 183706 More actions · Answer 1

Something like this?

DECLARE @SpecialChar char(3) = '%#%' --Example of special character

SELECT *

FROM myTable

WHERE Stringcol1 LIKE @SpecialChar

OR Stringcol2 LIKE @SpecialChar

OR Stringcol3 LIKE @SpecialChar;

Don't use this in production code. This should be a one time cleansing issue and you should prevent the special characters to get in the tables (that's why we have constraints).

Luis C.
General Disclaimer:
Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

How to post data/code on a forum to get the best help: Option 1 / Option 2

johnwalker10 SSCrazy Eights Points: 9124 More actions · Answer 2

Check out the following article maybe this will help you out: http://social.technet.microsoft.com/wiki/contents/articles/24169.sql-server-searching-all-columns-in-a-table-for-a-string.aspx