SQL query IFNULL

[Martin Kloss]

Hi Ruslan,

the following query produces an error, but the docs suggest
that this should work:

SELECT RecID, type, IF(comment IS NULL, 'n', 'j') FROM data, data_types 
ORDER BY type ASC

Martin.


Martin Kloss

Need music? http://www.selling-sound.com

Like the author? Buy the book at:
http://www.amazon.de/exec/obidos/ASIN/3898422194/lingmmugd

Get your daily dose of Lingo at the LingoPark:
http://www.lingopark.de