Re: Oracle varchar problem - Difficult

afilonov_at_pro-ns.net (Alex Filonov) wrote in <95p69a$7ut$1_at_nnrp1.deja.com>:

>
>update blob
>set dirty = 'Y', value = new_value
>where not(value = new_value)
>
>In case when either value or new_value is null, result of
>value = new_value is false, so this case is covered too.
>

However if the old and new values are both '' - then the field will be updated even though the data hasn't changed (i.e. dirty will be set to 'Y').

-- 
---
/* Christopher Burke - Spam Mail to craznar_at_hotmail.com
|* www.craznar.com - International Internet Writing Experiment
\* Real mail to cburke(at)craznar(dot)com