-
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
-
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
-
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
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
|
|