Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Location
    Thane, Maharashtra,India
    Posts
    17

    Unanswered: IsNull() equivalent in MS SQL 2000

    what is the ISNull () equivalent in MS SQL 2000?
    Syntax please

  2. #2
    Join Date
    Jul 2003
    Location
    The Dark Planet
    Posts
    1,401

    Does anyone not read the BOL ????

    Straight from the holy book ....
    ISNULL

    Replaces NULL with the specified replacement value.

    Syntax

    ISNULL ( check_expression , replacement_value )

    Arguments

    check_expression

    Is the expression to be checked for NULL. check_expression can be of any type.

    replacement_value

    Is the expression to be returned if check_expression is NULL. replacement_value must have the same type as check_expresssion.

    Return Types

    Returns the same type as check_expression.

    Remarks

    The value of check_expression is returned if it is not NULL; otherwise, replacement_value is returned.
    Get yourself a copy of the The Holy Book

    order has no physical Brett in The meaning of a Kaiser . -database data

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    enigma, why do you flog yourself so mercilessly?

    just tell them the equivalent is COALESCE and make them go look up the syntax themselves

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •