Hey all,
prolly a simple solution, but why isn't the following string working in
my execute sql step?

select x from new_files where x like '%[^0-9]%' and x like '%[^a-z]%'

Actually, it does work, however, it's displaying all the records? It
should only be displaying those records that do *not* contain letters
or numbers.

Thanks in advance!
-Roy

Roy,

It is impossible to tell without seeing DDL and data sampling.

Ilya

<roy.anderson (AT) gmail (DOT) com> wrote

Problem is, it will bring back all records with spaces using original
logic.

select * from new_files
where x not like '%[A-Z]%'
and x not like '%[0-9]%'

will stop any records appearing where there are not letters or
numbers.

What are you actually looking for in the anomolies from your query?

IMHO, it may be that the question you're asking isn't strict enough. I
usually find that once the actual question is defined the coding is
relatively simple.



roy.anderson (AT) gmail (DOT) com wrote: