You could try with the <> operator.
!=, <> Not equal operator
Or you could try it this way - ISNULL(col_or_data_to_check).
Example:
mysql> SELECT ISNULL(1+1);
+-------------+
| ISNULL(1+1) |
+-------------+
| 0 |
+-------------+
1 row in set (0.02 sec)
Aleksander
Chris wrote:
Chris wrote:
unknown compared to anything is unknown.
he was talking about plsql and condition evaluation (ends with true
or false), your point is absolutely useless.
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.
> TIA
>
>
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
