How would I filter out this column to display only english characters? Microsoft SQL Server Management Studio

Question

For the table above, how would I filter the column description so that it only shows English characters? (removes out the '????s' and the French characters etc)

I know it goes in the where clause, just can't figure out how.

Any help is greatly appreciated, thank you.

The bigger question possibly is whether you _want_ to filter off those other characters. If you are using the wrong collation, some of your legitimate data could be appearing as `??????`. — Tim Biegeleisen, Jan 18 '18 at 02:32

score 0 · Answer 1 · answered Jan 18 '18 at 02:57

I tried a lot, but I couldn't find anything in your case.

But, if your column doesn't hold more than one Question Mark(?) consecutively, this will helps you:

DECLARE @A TABLE(Name VARCHAR(16))
INSERT INTO @A VALUES ('A')
INSERT INTO @A VALUES ('தமிழ்')

SELECT *
FROM @A 
WHERE name not like '%??%'

Output:

Name
A

If you found any other solutions, mention my name in the comment. That will helps me.

score 0 · Answer 2 · answered Jan 18 '18 at 03:48

0

Try using NOT LIKE

SELECT *
FROM   Yourtable
WHERE  Description NOT LIKE '%[^a-Z]%'

answered Jan 18 '18 at 03:48

Pரதீப்

91,748
19
131
172

How would I filter out this column to display only english characters? Microsoft SQL Server Management Studio

2 Answers2