Return Names containing non-standard characters

[MrPeds]

Hi,

I have a table that contains a column of names.

Some of the names in the table contain non-English names, e.g. contain accents and special symobols.

I am basically wanting to write a query that will return me the rows where the name column contains characters that are not a-z and not A-Z.

Any ideas or suggestions are appreciated.

thanks,

MrPeds

 

[gmmastros]

Try this...

Select *
From   TableName
Where  Name Like '%[^a-z .]%'

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[mrdenny]

Or possibly this.

select *
from Table
Where name not like cast(name as varchar(255))

(Not tested)

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog