You can use the 'null predicate' (<expression> IS [NOT] NULL). And yes, it works with LONG columns too.
See http://dev.mysql.com/doc/maxdb/en/8c/ccce2ac71c11d2a97100a0c9449261/content.htm Regards Alexander Schr�der SAP DB, SAP Labs Berlin > -----Original Message----- > From: Ralf Becker [mailto:[EMAIL PROTECTED] > Sent: Saturday, August 07, 2004 8:58 AM > To: [EMAIL PROTECTED] > Subject: test long column for NULL in select > > > Hi all, > > I need on special value in a long-column, which I can test in a query. > > So far we used '' (empty string), but I know / tested MaxDB does not > allow a "long_column=''" or a "long_column LIKE ''" (as eg. > MsSql allows). > > So my last hope is to insert NULL in that column and test if > the column > is NULL. But I cant find anything about it in the MaxDB > documentation or > via google. Is there a IFNULL() function or something similar? > > As always, any help appreaciated > > Ralf > > -- > MaxDB Discussion Mailing List > For list archives: http://lists.mysql.com/maxdb > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
