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

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Sunday, December 29, 2013 8:57 AM
Points: 15, Visits: 35
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