Re: how to remove empty rows

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