[thelist] MS SQl help ASAP

[Brian Cummiskey]

i need some quick help, please answer as soon as you can if you have any 
ideas.

i have a query which is simple-

select * from blah
where blah = 1
and isnumeric(PersonalIdentifier) = 1



which works great.

however, the opposite is killing me.  i cannot figure out a way to query 
on the non-numeric data.

The table/program is set up so that numbers 0-100 are positive 
responses, and any alpha text is a refusal.

any ideas?

anyone have an isalpha() function they can share?

again, this is ms sql server 2000.

thanks in advance.