FORMfields, the premiere web framework
Login
Support Home | Knowledge Base | Documentation | Forums | Contact Us
Info
FORMfields & FORMgen :: Database

Format a Currency Amount Using a MySQL Query

(1901 views. Last Updated: 2007-08-09 1:10 PM)

Let's say you have a database attribute called "cost." You can use something like the following in a TableSet query:
SELECT CONCAT('$', cost) FROM mytable
Info
Support | Earn Money
Copyright © 2005-2018 Brain Book Software LLC.
Built with FORMfields, the premiere web framework.