I have a money field with 2 decimals. It will display fine in a grid, but I need to change it to a string and append something to it. I have tried
BO.strField = BO.price
BO.strField = AS_STRING(BO.price)
BO.strField = AS_STRING(BO.price, '#,##0.00')
And I always get the amount with NO commas and 1 decimal place.
Any suggestions please?
Bruce