Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
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: Tuesday, September 15, 2015 3:45 PM
Points: 66, Visits: 110
Wasn't aware of this behaviour of isnull !
Post #813355
Posted Wednesday, November 4, 2009 10:11 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 8:35 AM
Points: 1,032, Visits: 1,864
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: Monday, June 20, 2016 5:11 AM
Points: 307, Visits: 675
Thanx for the question

1+


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

Add to briefcase ««12

Permissions Expand / Collapse