Need Help with SQL Update

webrodie · Jan 24th, 2007, 13:26

I am needing an sql statement that will add one zero in front of the rest of the numbers that are already in a column row. For example I need all the data in a single column to be changed from "12345" to "012345".

My table name is "associate_list" and the column name is "disc". I need all the records to be updated for that column.

Thanks!!

TheSealPortalTeam · May 11th, 2007, 17:20

Firts read the value then update it by a string like
READ * from associate_list

dim intPrevNumber as int16 = reader.read("disc")

UPDATE ... dec='0" & intPrevNumber &' ...."