Niths (5/2/2010)
But still am not clear with the output.. u are comparing 2 expressions in ur query... one is int with value 0 and the other is null... both are of different value.. then how the output is null?
in this question ' ' (blank) will be treated as INT type means 0
.So 0 equal to 0 will give expected result
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)