Click here to Skip to main content
15,850,298 members
Please Sign up or sign in to vote.
5.00/5 (1 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 28-May-20 5:05am
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 27-May-20 12:42pm    
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 28-May-20 10:06am    
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

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
Share this answer
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, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900