Hi Guys,
I'm scanning a very large table using LIKE for a certain pattern and I want to exclude results that contain a number or dash. For dash I do something like NOT LIKE '%-%' and it works extremely fast, but is there any way to exclude numbers, without going through NOT LIKE '%1%' AND NOT LIKE '%2%' AND ...
The data is varchar(255).
Is there a regex solution? Any quick way to do this?
Thanks!
Luc L.
I'm scanning a very large table using LIKE for a certain pattern and I want to exclude results that contain a number or dash. For dash I do something like NOT LIKE '%-%' and it works extremely fast, but is there any way to exclude numbers, without going through NOT LIKE '%1%' AND NOT LIKE '%2%' AND ...
The data is varchar(255).
Is there a regex solution? Any quick way to do this?
Thanks!
Luc L.