[thelist] MS SQl help ASAP

[MCollins at seminolecountyfl.gov]

perhaps "isnumeric(PersonalIdentifier) = 0"?




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.
-- 






--****Florida has a very broad Public Records Law. Virtually all written 
communications to or from State and Local Officials and employees are 
public records available to the public and media upon request.  Seminole 
County policy does not differentiate between personal and business emails. 
 E-mail sent on the County system will be considered public and will only 
be withheld from disclosure if deemed confidential pursuant to State 
Law.****