Hi
I've got the following:
Table: Erf
Column Name : PortionNumber
DataType: varchar(5)
Records: 39000
The values of these records are all numbers that starts at 0 and ends at
200.
I would like to insert one or more '0', infront of all the numbers to make
sure that the length of each record are 5 numbers.
I know how to update a single record, but obviously 39000 wouldn't allow me
to have a weekend :)
Liana
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
