LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Programming (http://www.linuxquestions.org/questions/programming-9/)
-   -   SQL -any value for numeric or string field (http://www.linuxquestions.org/questions/programming-9/sql-any-value-for-numeric-or-string-field-788660/)

kpachopoulos 02-12-2010 07:17 AM

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

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 (Post 3861574)
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)


All times are GMT -5. The time now is 08:28 PM.