"Daniel Rail" <daniel@...> wrote in message
news:5.1.0.14.2.20020320142057.03d14d40@......

>
> Or maybe replace step 2 with:
> 2. update table set temp=substring(field_being_updated from 1 for 6)
> or should it be, since it's unicode:
> 2. update table set temp=substring(field_being_updated from 1 for 18)

Unlike the substr() and substrlen() UDFs, the built-in substring is
charset-aware. Use always the logical length. In your case, it would be 6.
But that's not your problem. The poor DFW got lost with your changes without
commits in the middle.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing