Venal
SSC-Addicted
Points: 463
More actions
July 20, 2013 at 8:55 pm
#280695
Hi,
select * from EMP
where comm is null -- 10 rows
where isnull(comm,'')='' -- 11 rows(comm is null&0-it was showing)
Can any one explain what is the diff?
Subbu
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply