Currency

[Shirley]

Anyone know how to format a field from a sql server database to currency. For example in sql the field appears as 83.3, I would like it to appear on the web page as $83.30.

 

[foxdev]

When you select the data from SQL Server, use:

convert(money, YourColumnName, 1) Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[Shirley]

Would this be on the SQL database table in design or once the Price field have been inserted on Front Page

 

[foxdev]

It would be when you run the query to extract the data, for example:

[tt]select MyColumn1, MyColumn2, convert(money, YourColumnName, 1) as Amount from MyTable...[/tt]

Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[Shirley]

Thanks for the help , I've fixed the problem.