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

Lathrop Preston ciapug@cialug.org
Tue, 06 Apr 2004 12:05:52 -0500


> 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.

Lathrop