> You might be able to use the CAST() function. > > http://dev.mysql.com/doc/refman/5.0/en/cast-functions.html
Unfortunately our producation machine is using MySQL 3.23.x and from what I've found the cast() function isn't available. :( "CAST() and CONVERT() are available as of MySQL 4.0.2."