SQL query IFNULL

Wed Oct 29 14:48:15 CST 2003

At 14:35 29.10.2003, you wrote:
> > all I get is "j", but some records don't have any data in the
> > field, so I assume it's empty.
> >
> > IF(comment IS NULL, 'n', 'j')
> >
> > gives me the same result.
>
>Try to check on small db with VAPP.

I don't have a Mac around to check, but I get the same result
in V4MD, viSQL and vStudio.

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