You could try with the <> operator.
!=, <> Not equal operator
Or you could try it this way - ISNULL(col_or_data_to_check).
mysql> SELECT ISNULL(1+1);
| ISNULL(1+1) |
| 0 |
1 row in set (0.02 sec)
he was talking about plsql and condition evaluation (ends with true
or false), your point is absolutely useless.
unknown compared to anything is unknown.
The context is in the database - my example is in the database. How
is that useless?
In case you missed it, this is the context:
> Which only works when ShipDate was not NULL to begin with.
> I suppose it evaluates the following to FALSE
> IF NULL != '2008-10-31' AND '2008-10-31' IS NOT NULL THEN
> (not liking the "NULL != '2008-10-31'" part)
> Please give me the correct syntax.
anything compared to NULL is always false
ie - you are wrong.
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php