RE: Picturing numeric data...

[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/e

Picturing numeric data...

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 ___