Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2012 Forums
 Transact-SQL (2012)
 procedures where having charters else English

Author  Topic 

MohamedAliSalim
Starting Member

9 Posts

Posted - 2015-05-06 : 04:34:57
How to select all procedures having charters else English in SQL ?

Mohamed Ali Salim

Kristen
Test

22859 Posts

Posted - 2015-05-06 : 05:54:34
Maybe this?

WHERE MyColumn LIKE '%[^ -~]%'

Go to Top of Page

MohamedAliSalim
Starting Member

9 Posts

Posted - 2015-05-06 : 06:23:28
No not working :(

Mohamed Ali Salim
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2015-05-06 : 07:10:26
Please post an example of the data you need to match, and the Collation you are using.
Go to Top of Page
   

- Advertisement -