Post reply

Select and replace field NULL

  • March 20, 2006 at 1:53 pm

    #189738

    Hello,

    In my result, I want to replace NULL by 0 in my query.

    Exemple :

    Nom         SUM

    --------------------------

    Michel       99,9

    Sandra      NULL

    Julie         49

    I would like this result :

    Nom         SUM

    --------------------------

    Michel       99,9

    Sandra      0

    Julie         49

     

    Thanks

    Kindest Regards,

    degrem_m
    Degremont

  • March 20, 2006 at 2:14 pm

    #627710

    look up isnull function in bol.

  • March 20, 2006 at 2:29 pm

    #627719

    Thanks

    Kindest Regards,

    degrem_m
    Degremont

  • March 21, 2006 at 4:22 am

    #627822

    And/Or set a default.

    ALTER TABLE tablename

    ADD CONSTRAINT columnname_default

    DEFAULT 0 FOR columnname

  • March 24, 2006 at 5:09 pm

    #628760

    If NULL is a legitimate value ie. (NO VALUE), 0, 1, 2 you can use the COALESCE function to get the result your looking for. ie. the following example return's eight when Field1 is null

     

    SELECT

     

       [Name],

       COALESCE( [Field1], 8 )

     

    FROM

     

       TABLE

Viewing 5 posts - 1 through 4 (of 4 total)

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