Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

ISNULL Expand / Collapse
Author
Message
Posted Tuesday, November 3, 2009 6:03 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, January 29, 2014 5:01 AM
Points: 66, Visits: 105
Wasn't aware of this behaviour of isnull !
Post #813355
Posted Wednesday, November 4, 2009 10:11 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 8:52 AM
Points: 916, Visits: 1,722
Noel McKinney (11/3/2009)
This is the main reason I make it a habit to use COALESCE rather than ISNULL unless there's a reason I need the behavior of ISNULL.

I wasn't aware of that ISNULL property or that COALESCE does NOT truncate that way. I've been switching to using COALESCE on occasion because I understand that it's ansi-standard, but now I have an additional reason to use COALECSE.

Thank for a good question.
Post #813711
Posted Thursday, June 6, 2013 12:51 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, September 27, 2013 5:37 AM
Points: 306, Visits: 524
Thanx for the question

1+


Neeraj Prasad Sharma
Sql Server Tutorials
Post #1460541
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse