How to select blank values

• SkyBVI

  SSCoach

  Points: 15115

  More actions

  April 5, 2011 at 9:24 am

  #248975

  Hi,

  I made a table out of joins of 2-3 tables..

  In 2-3 columns of my resulting table, I am getting blank ( no result)

  The sql server shows it as NULL.

  But When i query it as

  select * from table

  where columnname ='NULL'

  it doesnt show those rows as its empty not NULL value...

  I want to see such values..

  How to do it

  Regards,

  Sushant

  Regards
  Sushant Kumar
  MCTS,MCP

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  April 5, 2011 at 9:33 am

  #1307539

  1 - SELECT * FROM table where Column IS NULL

  2 - Are you using left joins? That could cause the same issue.

• SkyBVI

  SSCoach

  Points: 15115

  More actions

  April 5, 2011 at 9:59 am

  #1307566

  Ninja's_RGR'us (4/5/2011)

  ---

  1 - SELECT * FROM table where Column IS NULL

  2 - Are you using left joins? That could cause the same issue.

  Yes, tht did d trick...

  Yes, i am using left joins, because of the nature of result i want...

  Regards,

  Sushant

  Regards
  Sushant Kumar
  MCTS,MCP