[snip] 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.... [/snip] Start here http://www.mysql.com/doc/en/String_functions.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
