Post reply

IsNull

  • January 14, 2011 at 9:37 am

    #388640

    What is the difference between:

    IsNull(field)

    and

    IsNull(Field,0)

    Thank You

  • January 14, 2011 at 9:55 am

    #1273656

    The first is used by SSIS to do a NULL test, ie: ISNULL(Field) returns true or false. The second is SQL saying that is the value is NULL then replace it with the second argument. There is also a .IsNull in relation to the geography datatype.

    Clear?

    CEWII

  • January 14, 2011 at 10:09 am

    #1273668

    Ah...thanks!

  • January 14, 2011 at 10:35 am

    #1273684

    You are welcome.

    CEWII

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

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