SQL -any value for numeric or string field

kpachopoulos · 02-12-2010, 07:17 AM

Hallo,
how do i ask in a query for any numeric or string field? It may not have any meaning, but i need it to fill a toplink DataReadQuery in java....

Something like " select * from table where table.fieldA='?' "

Thanks

redgoblin · 02-12-2010, 10:14 AM

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?

kpachopoulos · 02-12-2010, 10:53 AM

Quote:

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)