General information
Category:
Coding, syntax & commands
Title:
Can TRANSFORM be made to right justify an amout
Been trying to figure out how to make a "money" result in a select statement appear right justified.
For example, using
"SELECT COUNT(*), TRANSFORM((SUM(MTON(amount))*-1), '@$B 999,999.99') AS money, field2 FROM mydb GROUP BY field2" etc, forces a beautiful "LEFT" justified "$123,456.78" along with "$1.23", etc., as in
"$123,456.78"
"$1.23"
but how do we make this right justify? as in
"$123,456.78"
"$1.23"
That is the question. TIA. /psb
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only