Originally Posted by redgoblin
Do you mean you want the result set to consist of any fields in the data set that's either numeric or text?
Or do you mean you want records where a certain field (or fields) contain numbic or text values?
Thanks for the response, i found it...
select * from table where table.fieldA IS NOT NULL;
(this would return the whole table in this case)