<div>
Is this what you are looking for?<br />
<br />
SELECT address FROM users where address LIKE '%[^A-Za-z]%'<br />
<br />
The ^ is like Not<br />
<br />
This might work;<br />
SELECT address FROM users where address NOT LIKE '%[A-Za-z]%'
</div>


Is this what you are looking for?

SELECT address FROM users where address LIKE '%[^A-Za-z]%'

The ^ is like Not

This might work;
SELECT address FROM users where address NOT LIKE '%[A-Za-z]%'

<div>
<div class="content wysiwyg-content">
Hi !<br />
<br />
I need to find a way to query my SQL 2008 database to find all caracters that are not a-z, A-Z and &quot;-&quot; in the column named &quot;address&quot;.<br />
<br />
The database collation is : Latin1_General_CI_AS<br />
<br />
I've try to do &quot;SELECT address FROM users where address LIKE '%é%' but this was not effective.<br />
<br />
-M 
</div>
</div>


Hi !

I need to find a way to query my SQL 2008 database to find all caracters that are not a-z, A-Z and "-" in the column named "address".

The database collation is : Latin1_General_CI_AS

I've try to do "SELECT address FROM users where address LIKE '%é%' but this was not effective.

-M 

TSQL : Find non a-z, A-Z, &quot;-&quot; caracters in a column

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

TSQL : Find non a-z, A-Z, &quot;-&quot; caracters in a column

TSQL : Find non a-z, A-Z, "-" caracters in a column