Remember: You can't test null values using (=3D, <>, etc). You need to use ( is null, is not null, or NVL) Waleed -----Original Message----- From: Ben Sauer [mailto:SauerBL@xxxxxxxxxxxxx]=20 Sent: Thursday, September 23, 2004 5:15 PM To: oracle-l@xxxxxxxxxxxxx Subject: Trigger problem... Probably pretty basic... but I've got a trigger that needs to execute when the new VarChar2 field <> the old VarChar2 field. In other words on Change. But it seems that <> has strange results with them in the trigger. Am I supposed to use some alternate function like .equals() in Java. If so would somebody mind some syntax for me? Thanks,=20 Ben ------------------------------------------------------------------------ ------ This message may contain confidential information, and is intended only for the use of the individual(s) to whom it is addressed. ------------------------------------------------------------------------ ------ -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l