Pandian S

 Profile Answers by Pandian S Questions by Pandian S

• Mar 5th, 2007

 

Hi

1. Without any Null Value for Column1:
Select * From Table1 Where Column1 Is Not Null


2. Instead of Null values it returns as '0':
Select IsNull(Column1,0) Column1,* From Table1

anjan_maity

 Profile Answers by anjan_maity 

• Aug 7th, 2008

 

use IsNULL(<expression>,value) .
If query return null ,it will replace by  value.