Re: how to remove empty rows

Jean-Yves F. Barbier wrote:
> e-letter wrote:
>> The command 'INSERT INTO' was used to enter the sum of a mathematical
>> function into a table. On a condition, the result was null, causing
>> the creation of an empty row in the table.
>>
>> Using tho command 'DELETE' with the expression:
>>
>> ...=NULL;
>>
>> does not remove the empty row. How to remove please?
>
> NULL is *NOT* a value; use ISNULL to test.

Thus comparison to equal NULL ( = NULL) or to not equal NULL ( != NULL) can
never succeed. That's why SQL has "IS NULL" and "IS NOT NULL".

--
Lew
Honi soit qui mal y pense.
http://upload.wikimedia.org/wikipedia/commons/c/cf/Friz.jpg