NULL Problem

[kandan]

Hi all,

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

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

adv thanxx,
kandan.

[Eclipse DevSoft]

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

[KenX]

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

[venkatraman_r]

Ennada kandus,

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

Venkat.

[kandan]

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.

[venkatraman_r]

hi kandus,

cuppundranunga kadainnuranugga..ketta nullundranunga..


Venkat.

[kandan]

hi venkat mama,

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

kandan.

[venkatraman_r]

hi da mama,

inga aapadipangada..nothing like that....