Greetings... I have a double column (id) that has data like -
-123.123 1.1 0.001 200.001 -123.4 Is there any query wherein I can get formatted resultset like - -#123.123# +###1.1#### +###0.001# +#200.001# -#123.4### Any MySQL function or a workaround.... Thanks in advance? Karam __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]