var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: using update to increment a varchar by 1
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 ....
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.
sounds good, ill try that out.