Post reply

SQL Panel

  • December 16, 2002 at 11:44 am

    #79506

    I have a database table that for the email field has NULL values. I want to be able to select all the records in the email Field that has null values so i can convert them to another field. How do i write this Query in SQL 2000. I keep getting error messages. Please help.

  • December 16, 2002 at 12:03 pm

    #444508

    Select * from Table where email field is null.

    What kinds of errors? even if you did it with = null, it wouldn't give errors. How are you going about it now?

  • December 16, 2002 at 12:11 pm

    #444509

    I am currently doing it like this

    SELECT *

    FROM Members

    WHERE (EMAIL = NULL)

    Well i am not getting an error now. But it just displays one record with nothing in it. But if i open the database i see the <NULL> values under the email field for lots of users. I don't understand it.

  • December 16, 2002 at 12:21 pm

    #444512

    SELECT *

    FROM Members

    WHERE (EMAIL is NULL)

  • December 16, 2002 at 12:26 pm

    #444514

    Thanks Tad that worked.

  • December 16, 2002 at 1:09 pm

    #444524

    That was what I suggested.

    The evaluation of null is performed differently in 2000. Its more in line with VB now. For years Null was treated as a value, while in fact it is a state. Now it is being treated as a state, not a value. Someone just posted an article on exactly this a few days ago. You might look for it.

  • December 16, 2002 at 1:39 pm

    #444529

    Thanks Scorpian 66. I appreciate your help allot. I'll look for that article.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply