SQL & PL/SQL

Dear All,

I am getting No data found error while executing the following UPDATE statement.

UPDATE DEAL
SET CLIENT_CD = 'HDMJARVN'
WHERE CA_REF_NO = 70728
AND CLIENT_CD = 'HDMJARVI';

Wheareas

SELECT *
FROM DEAL
WHERE CA_REF_NO = 70728
AND CLIENT_CD = 'HDMJARVI';

Gives me 1 row.

Please explain.....

Thanks in Advance.