Hi guys, I'm working in Raw C under UNIX and using Ingres. I'm trying to return data from a varchar, but I only want it if in contains ANY characters that are NOT numeric. (IE: A5555, AAAAA, 555A4) Any help ? Can it be done via the query or do I have to do it after I've filled my recordset ?

I'm actually now using :-

SELECT field FROM table WHERE field < '0' OR field > '9'

This seems to be working, I thought there might be some fuction that would do it faster/better (250000+ rows)