Click here to Skip to main content
14,545,256 members
Rate this:
Please Sign up or sign in to vote.
See more:
How to eliminate non-english characters using SQL query?

What I have tried:

Used the below query but not working.

select * from table where column not like '%[A-Z]%'
Updated 3 days ago
Richard MacCutchan 18-May-20 12:31pm
What does "not working" mean? What data is in the column field of table, and what results did you receive?
jsc42 18-May-20 12:40pm
As is, the query would find rows where column 'column' does not have any letters in the range A to Z. I guess the OP is looking for rows where column 'column' only contains the letters A through Z, which is a lot trickier. Even if the correct LIKE is used, it wouldn't eliminate anything, it just wouldn't select specific rows to be returned in the query
Avishek Biswas 4 days ago
I have used the below query for the extraction of the data, but it is not working.
Used the below query for the extraction, but it's not giving the correct values.
select * from table where (Replace(ISNULL('(data/data1/data2/)', 'nvarchar(50)'),'') like '%[a-zA-Z0-9]%'

Avishek Biswas 3 days ago
i want to eliminate Japanese, thai and Indonesian characters using the query.

For example, the database consists of 5 records, コンサート, sandra, leonardo, 昨夜, 最高, jerry.

Then, in the result, it should return sandra, leonardo, jerry.

Please let me know.

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

Try adding COLLATE SQL_Latin1_General_CP1253_CI_AI to your SELECT:
SELECT * FROM MyTable WHERE Title LIKE '%e%'
COLLATE SQL_Latin1_General_CP1253_CI_AI
Maciej Los 18-May-20 15:54pm

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100