Results 1 to 3 of 3

Thread: Null value

  1. 03-15-2001, 12:33 AM #1
    SAM Guest

    Null value

    The result of one of my sql query has lots of Null values. I am trying to transform Nulls into some other value such as UNKNOWN, since I do not want null values appearing in my data. Please help.

    Thanks in advance
    Sam


    Reply With Quote Reply With Quote
  2. 03-15-2001, 02:33 AM #2
    Chris H Guest

    Null value (reply)

    Have a look in BOL at ISNULL().

    Chris H


    ------------
    SAM at 3/15/01 12:33:11 AM

    The result of one of my sql query has lots of Null values. I am trying to transform Nulls into some other value such as UNKNOWN, since I do not want null values appearing in my data. Please help.

    Thanks in advance
    Sam


    Reply With Quote Reply With Quote
  3. 03-15-2001, 02:29 PM #3
    SAM Guest

    Null value (reply)

    Chris, thanks alot. ISNULL work very well. However, I can not seems to get ISNULL to work on a datetime field. I am trying to replace NULLS on a datetine field with another value. It does have to be the vaLue UNKNOWN.
    Please help.

    Thanks in advance.

    SAM


    ------------
    Chris H at 3/15/01 2:33:49 AM

    Have a look in BOL at ISNULL().

    Chris H


    ------------
    SAM at 3/15/01 12:33:11 AM

    The result of one of my sql query has lots of Null values. I am trying to transform Nulls into some other value such as UNKNOWN, since I do not want null values appearing in my data. Please help.

    Thanks in advance
    Sam


    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules