NULL Problem

Hi all,

In a SQLSERVER whether a NULL=NULL or NULL!=NULL????

anyone can help me out from this??????

adv thanxx,
kandan.

Null is SQL Reserved word so if you use it without a recordset, enclosed it in brackets:
"UPDATE MyTable SET [Null] = Null" or
"INSERT INTO MyTable ([Null], Field2) VALUES (Null, Value2)"

Otherwise, assign Null as usual:
rs!Null = Null or
rs.Fields("Null") = Null

i can't quite get ur question but
perhaps it would help if you use
"Is Null" when testing...

Ennada kandus,

enna solranunga...ultimately is null equals or not equals null?? ;)

Venkat.

hi all,

thanxx for ur reply...but that not i wanted..
all i want is ..in SQLSERVER a NULL is equal to a NULL or notequal to NULL..thats all.

again thanxxx,
kandan.

hi kandus,

cuppundranunga kadainnuranugga..ketta nullundranunga..
:):)

Venkat.

hi venkat mama,

dai icq ella yahoomess ethuna openn panni irrukiya daa..
tell me..

kandan.

hi da mama,

inga aapadipangada..nothing like that....