Update != <> not working in where class

[swami]

Dear experts!

SELECT DOC_NO,PRESENT_USER FROM UDBA.TRNRESERVHDR WHERE DOC_NO=390;

DOC_NO PRESENT_US
------ ----------
390 udba

UPDATE UDBA.TRNRESERVHDR SET PRESENT_USER='swam' WHERE PRESENT_USER!=NULL AND DOC_NO=390;
(or)
UPDATE UDBA.TRNRESERVHDR SET PRESENT_USER='swam' WHERE DOC_NO=390 AND PRESENT_USER<>'';
commit;

When I Execute the statement no message is comming after that when i select the record.!!!! It's not updated..
SELECT DOC_NO,PRESENT_USER FROM UDBA.TRNRESERVHDR WHERE DOC_NO=390;

DOC_NO PRESENT_US
------ ----------
390 udba

But
UPDATE UDBA.TRNRESERVHDR SET PRESENT_USER='swam' WHERE DOC_NO=390;
commit;
SELECT DOC_NO,PRESENT_USER FROM UDBA.TRNRESERVHDR WHERE DOC_NO=390;

DOC_NO PRESENT_US
------ ----------
390 swam

it's updating.!!!! ????

Can any one explain me....??

regards
swami

[weblogic]

UPDATE UDBA.TRNRESERVHDR SET PRESENT_USER='swam' WHERE PRESENT_USER IS NOT NULL AND DOC_NO=390;
(or)
UPDATE UDBA.TRNRESERVHDR SET PRESENT_USER='swam' WHERE DOC_NO=390 AND PRESENT_USER<>'';
commit;


No comment on your naming conventions.

[Tim Scarfe]

<blockquote id="quote"><span class="smalltext" id="quote">quote:<hr id="quote">No comment on your naming conventions.<hr id="quote"></blockquote id="quote"></span id="quote">

Hah! Job security I'm sure...

--
Regards,
Tim Scarfe <tim@developer-x.com>
http://www.developer-x.com