[ciapug] MySQL table data - "1" and "01" different values

[Ryan O'Rourke]

On Tue, 2004-04-06 at 12:05, Lathrop Preston wrote:
> > Apparently CAST was introduced into MySQL 4.0.2 - unfortunately my
> > webhost is using 3.23.58.
> > I'd like to know if this works or not. Can anyone test this method and
> > report back?
> 
> then the separtate numeric index is probably your best bet.

Thanks for your help Dave, David, and Lathrop.
I ended up adding a car number_index field as TINYINT and modifying the
car_number field to CHAR.
Next season I'm sure my webhost will have updated their version of MySQL
and I will be able to try out the CAST function.

-- Ryan