Return sql rows where field contains ONLY non-alphanumeric characters

Question

I need to find out how many rows in a particular field in my sql server table  contain ONLY non-alphanumeric characters   I m thinking it s a regular expression that I need along the lines of   a-zA-Z0-9  but Im not sure of the exact syntax I need to return the rows if there are no valid alphanumeric chars in there

User · Accepted Answer

SQL Server doesn t have regular expressions  It uses the LIKE pattern matching syntax which isn t the same    As it happens  you are close  Just need leading trailing wildcards and move the NOT   WHERE whatever NOT LIKE    a-z0-9

User · Answer

If you have short strings you should be able to create a few LIKE patterns     a-zA-Z0-9       a-zA-Z0-9   a-zA-Z0-9         to match strings of different length  Otherwise you should use CLR user defined function and a proper regular expression - Regular Expressions Make Pattern Matching And Data Extraction Easier

User · Answer

This will not work correctly  e g  abc  xyz will pass thru this as it has a b c    you need to work with Collate or check each byte

[sql] Return sql rows where field contains ONLY non-alphanumeric characters

Examples related to sql

Examples related to sql-server

Examples related to regex

Examples related to tsql