Data-Checking step not working? - 01-05-2005 , 12:33 PM
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
Thanks in advance!
Re: Data-Checking step not working? - 01-09-2005 , 01:29 PM
It is impossible to tell without seeing DDL and data sampling.
<roy.anderson (AT) gmail (DOT) com> wrote
Re: Data-Checking step not working? - 01-12-2005 , 12:04 PM
Problem is, it will bring back all records with spaces using original
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
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
roy.anderson (AT) gmail (DOT) com wrote: