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.