Is there a way to use CAST() to convert a string MySQL field to a 'float'
value? I know I can convert a string to a SIGNED or UNSIGNED integer value,
but not float. I tried FLOAT, DECIMAL, and a few others and they were all
rejected. Right now I am using the following bit of silliness to get around
it:
CAST(strField * 100 AS SIGNED)/100
But I am hoping there is something more direct.
Thanks.
--
Robert Oschler
http://www.robotsrule.com/phpBB2/
Robot & Android Discussion Forum