[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