>i have a 1 character column that now needs to be two characters. i would also like to insert a leading 0 as the first character in the new two character column. so if the old value was '1', i would now like to have '01'.
>
>thanks
>
>brenda
ALTER TABLE MyTable ALTER COLUMN MyColumn C(2)
REPLACE ALL MyColumn WITH "0" + MyColumn
Erik Moore
Clientelligence