Thread: how to remove empty rows

how to remove empty rows

From
e-letter
Date:
Readers,

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?

Re: how to remove empty rows

From
"Jean-Yves F. Barbier"
Date:
On Tue, 26 Apr 2011 22:37:56 +0100, e-letter <inpost@gmail.com> 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.


--
A diplomat is man who always remembers a woman's birthday but never her age.
        -- Robert Frost

Re: how to remove empty rows

From
Lew
Date:
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