[thelist] MS SQl help ASAP
Brian Cummiskey
Brian at hondaswap.com
Tue Jan 4 14:55:11 CST 2005
Matt Warden wrote:
>
> select * from blah
> where blah != 1
> and isnumeric(PersonalIdentifier) = 0
>
> (note the and)
that's not going to work either. the "blah !=1" is pretty much
unrelated to the "and" part of the query, so i can't turn it around like
that.
This is what i've come up with so far that gets me the closest...
select * from blah
where foo = bar
and PersonalIdentifier NOT IN( select distinct(personalidentifier)
from blah
where isnumeric(personalidentifier) = 1)
but im still off by about 5-8% of my expected result set.
More information about the thelist
mailing list