Identifying foreign characters in rows of data

[negmat]

Guys,

I have a table with a single VARCHAR column. The COLLATION for this column is SQL_Latin1_General_CP1_CI_AS. Some of the values contain 'greek' or other European language characters (e.g. µ).

Does anyone know how I can identify all the rows in a table which contain non-english characters?

I was thinking to use something like the following:

SELECT TOP *
FROM TestTable
WHERE NAME NOT LIKE '%[A-Z]%'

... but that does not seem to work

Any ideas?
Thanks a lot

[scripto]

Guys,

I have a table with a single VARCHAR column. The COLLATION for this column is SQL_Latin1_General_CP1_CI_AS. Some of the values contain 'greek' or other European language characters (e.g. µ).

Does anyone know how I can identify all the rows in a table which contain non-english characters?

I was thinking to use something like the following:

SELECT TOP *
FROM TestTable
WHERE NAME NOT LIKE '%[A-Z]%'

... but that does not seem to work

Any ideas?
Thanks a lot

here you go...

select * from TestTable
where PATINDEX('%[A-Z,0-9]%',Name) = 0