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

isnull & isnull(comm,'')='' difference? Expand / Collapse
Author
Message
Posted Saturday, July 20, 2013 8:55 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, March 9, 2016 4:20 AM
Points: 25, Visits: 52
Hi,

select * from EMP
where comm is null -- 10 rows

select * from EMP
where isnull(comm,'')='' -- 11 rows(comm is null&0-it was showing)

Can any one explain what is the diff?

Subbu
Post #1475793
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse