On Fri, 13 May 2005 08:29:46 +0200, wrote: >Hi, >if the first characters are numerics, no need to use regexp, since mysql does >implicit conversion if you do calculations : > >mysql> select '10.95 tiitti' from dual; >+--------------+ >| 10.95 tiitti | >+--------------+ >| 10.95 tiitti | >+--------------+ >1 row in set (0.09 sec) > >mysql> select '10.95 tiitti'+0 from dual; >+------------------+ >| '10.95 tiitti'+0 | >+------------------+ >| 10.95 | >+------------------+ >1 row in set (0.02 sec) > Mathais Can I write the clean value back? , (i will give it a try)
-- zzapper vim -c ":%s%s*%Cyrnfr)fcbafbe[Oenz(Zbbyranne%|:%s)[[()])-)Ig|norm Vg?" http://www.rayninfo.co.uk/tips/ vim, zsh & success tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]