When is null really a null? I have run into this in SQL Server and SQL Anywhere.
It looks null but is was really '' So if I search for "column is null" nothing would show But if I searched for "column = ''" it would find them I had to resort to custom column length(column) < 1 Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Authorized MDaemon Mail Server Reseller http://www.pcforge.com/AltN.htm -----Original Message----- From: Roland Dumas [mailto:[EMAIL PROTECTED] Sent: Thursday, September 04, 2003 10:52 AM To: WiTango List Subject: Witango-Talk: empty argument I have a search action that looks for <@ARG 1> = column1 AND <@ARG 1> = column2 AND column1 is not NULL AND column2 is not NULL so if someone does an empty form, it should return nothing. It never does. Always gets a foundset. Same records, in fact. It finds records that have null content in column1 and column2 (mysql) (I can trap for empty arguments, but this seems odd) ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
