I am trying to figure out the sql that can give me the following.

Increment a value of say, 001, by 1 for a field that is a varchar.

Im thinking something like this but its incorrect.

update table set CAST(varchar_field AS INTEGER)=001 + 1 where ....

thanks.

You want something like: update mytable set varchar_col = char(integer(varchar_col) + 1) where ...

Be warned that if the column has non-numeric data it will fail.

Andy

sounds good, ill try that out.

thanks !