isnull & isnull(comm,'')='' difference?

• 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

  select * from EMP

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

  Can any one explain what is the diff?

  Subbu