I have a trigger something like ..... UPDATE X SET A=(SELECT ..... )
Now, if the embedded SELECT statement returns no rows I would NOT like to change the value from A to "bank/null" but let it keep the value it currently has. Any suggestions for a one liner which fits into a create trigger statement B-)
