Thanks Bricklen,
That's exactly what I needed.
--
Julian Milano
"Bricklen" <bricklen-rem_at_yahoo.comz> wrote in message
news:rVDlb.31416$i92.29229_at_clgrps13...
> Prince Of Thieves wrote:
>
> > I want to change all single digits to double digits, eg. 1=>01, 2=>02,
etc.
> > The digits are in a TEXT field and there are some double digit and alpha
in
> > the same field.
> >
> > I tried the following syntax but got an error:
> >
> > UPDATE vmigrp SET clustcd = "0" & clustcd
> > WHERE Length(clustcd)=1;
> >
> > And the error is "Var Parse Error" and another soon after "ORA-00933:
SQL
> > command not properly ended".
> >
> > Can this be done?
> >
> > --
> >
> > Julian Milano
> >
> >
> UPDATE vmigrp SET clustcd = '0'||clustcd WHERE Length(clustcd)=1;
>
> Check out --> tahiti.oracle.com.
>
Received on Wed Oct 22 2003 - 18:19:00 CDT
