Skip to navigation
How find rows what included not defiend characters
21.01.15
SELECT s.field1 ,s.field2 ,b.field3 FROM table1 as s LEFT JOIN table2 as b ON s.field1 = b.field1 where PATINDEX('%[^a-ZA-Z0-9-_./+]%',field1) =1 or PATINDEX('%[^a-ZA-Z0-9-_./+]%',field1) =2 or PATINDEX('%[^a-ZA-Z0-9-_./+]%',field1) =3 or PATINDEX('%[^a-ZA-Z0-9-_./+]%',field1) =4 or PATINDEX('%[^a-ZA-Z0-9-_./+]%',field1) =5 or PATINDEX('%[^a-ZA-Z0-9-_./+]%',field1) =6 or PATINDEX('%[^a-ZA-Z0-9-_./+]%',field1) =7 or PATINDEX('%[^a-ZA-Z0-9-_./+]%',field1) =8
https://myridia.com/ms188395
Reply
Anonymous
Information Epoch 1732567499
Development is an iterative process.
Home
Notebook
Contact us