SQL -any value for numeric or string field
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='?' "
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?
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 01:50 AM.|