cfml

That Amount column is float in the database. Should I change it?

<@UJH6CSDUL> did you put _any_ effort in to checking the docs for yourself before asking us? Or even just google?

I mean just googling "<https://www.google.com/search?q=cfml+How+can+I+make+a+format+mask+for+money&amp;oq=cfml+How+can+I+make+a+format+mask+for+money|cfml How can I make a format mask for money> " answers your question on the first page of results (<https://www.google.com/search?q=cfml+How+can+I+make+a+format+mask+for+money&amp;oq=cfml+How+can+I+make+a+format+mask+for+money>).

And using a more sensible search string is, unsurprisingly, even more focused: <https://www.google.com/search?q=cfml+money+format>

Slightly off topic - but I would strongly recommend storing monetary values as integers (so cents / pence instead of dollars and pounds). Then any maths operations you do are on integers and you just _display_ with decimal places.