SQL -any value for numeric or string field
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 |
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? |
Quote:
select * from table where table.fieldA IS NOT NULL; (this would return the whole table in this case) |
All times are GMT -5. The time now is 08:26 PM. |