View Single Post
  #1 (permalink)  
Old Jan 24th, 2007, 13:26
webrodie webrodie is offline
Junior Member
Join Date: Aug 2006
Location: United States
Posts: 15
Thanks: 0
Thanked 0 Times in 0 Posts
Need Help with SQL Update

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!!
Reply With Quote