On Wed, Sep 25, 2002 at 05:33:42PM -0400, Tanton Gibbs wrote: > Here is how to do it in mysql > http://www.mysql.com/doc/en/Cast_Functions.html
Have you tried it on the type of data the original poster was mentioning? I'm suspecting it's going to have a problem when trying to cast "1b" as a number. Unfortunately, I don't have access to any mysql 4.0.x installations to try it out. Michael -- Administrator www.shoebox.net Programmer, System Administrator www.gallanttech.com -- -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]