I have a char(30) variable in the database that in some instances it has 2/2/2009 and some have 02/02/2009. I am wanting to write an sql update query that goes through and updates all instance of m/d/yyyy to mm/dd/yyyy how do I do this being that it is of type char?

This was a result of data entry problem, different people entered data in different ways, and now that we have to go back through and change it.