While there may be a way to manipulate this with MySQL, you may find
that the interface language is simpler. PHP and Perl both offer a
command 'printf' which allows you to heavily format a string or
number. Like:
printf("The price is $%.2f, today only", $sqlResultRow->amount);
would yield "The price is $24.95, today only". This differs a bit
between perl and PHP, but it's pretty much the same.
Nelson
>Anyone know how to get a field in one of my table in a form that any number
>that I want to be displayed as 0.20 doesn't round off as 0.2? So 0.20 for
>the cost instead of 0.2?
>
>Or do I have to do this with the Server Side Language I'm using to format
>the value? Or some extra SQL command?
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php