DynDeveloper.com

DynDeveloper.com

Sign Up Now! Log In
Malachi 10/6/2016 3:17:44 PM

FORMAT - Format a number as a string, include the currency symbol and use the correct decimal place

* This article, and all our great SQL (General) documentation, Is available on the SQL (General) menu

Here's the question, see if you can guess the best answer before reading mine

So, you have to write a query that returns a number, you want to format that numeric value properly, like this: $122.00

The decimal place has to come from the SOP DECPLQTY field

 

Version: All
Section: SQL Scripts