1 2 3 4 5 6
| where
(substr(monchamp,1,1) not between '0' and '9' and substr(monchamp,1,1) not between 'A' and 'Z' and substr(monchamp,1,1) not between 'a' and 'z')
or (substr(monchamp,2,1) not between '0' and '9' and substr(monchamp,2,1) not between 'A' and 'Z' and substr(monchamp,2,1) not between 'a' and 'z')
or (substr(monchamp,3,1) not between '0' and '9' and substr(monchamp,3,1) not between 'A' and 'Z' and substr(monchamp,3,1) not between 'a' and 'z')
or (substr(monchamp,4,1) not between '0' and '9' and substr(monchamp,4,1) not between 'A' and 'Z' and substr(monchamp,4,1) not between 'a' and 'z')
... |
Partager