Results 1 to 4 of 4
  1. #1
    Join Date
    May 2004
    Posts
    4

    Unanswered: date IS NULL not working......?

    Hi,

    I have a problem with a SQL that check if a date column IS NULL.
    On one server the check work ok but on another (the same data is on both - restored copy) the check does not find any NULL values.
    If check where datecolumn =convert(datetime,'9999-12-31 23:59:59.000',121) I get the same result as when checking for NULL in the other.

    Is there any parameter set somewhere that tell the server to return a value even if NULL is stored in the database?

    thank you for reading,
    YakoBay

  2. #2
    Join Date
    Feb 2004
    Posts
    492
    Quote Originally Posted by YakoBay
    Is there any parameter set somewhere that tell the server to return a value even if NULL is stored in the database?
    I'd be very surprised.

  3. #3
    Join Date
    Jul 2004
    Posts
    7
    Have you tried ISNULL( column, 'default value' )?

  4. #4
    Join Date
    Aug 2003
    Location
    Kingston, Ontario
    Posts
    106
    See COALESCE in BOL.

Posting Permissions

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