faridah27

Its work, but not the solution that i want...I've found the solutionselect * from <tablename> set <columnname>= '00' + <columname>Thanks for your concern...

I have a problem to update a bulk of valueI want to know how to update a bulk of value for example value 123456, 112233, 223344 and many else to become to 8 characters which is 00123456, 00112233, or 00223344...How should I do this at once?I just one to know the syntax that I should use to make all this 6 characters, to become 8 characters using one command only...StaffNo <New StaffNo>123456 00123456112233 00112233223344 00223344Thanks for your concern