I want to show numbers with thousand separator in query result. For example:
SELECT FormatFunction(MyNumberField) FROM MyTable
In which FormatFunction is supposed to be a function that formats the number as I want.
The embedded HSQLDB version 1.8xx does not appear to support the sql FORMAT function (for an example of this function see link text.
With the embedded HSQLDB you can temporarily change the format of a tabular query display by right-clicking on the column heading and choosing column format. This setting won’t be retained. Or you can edit the underlying table and change the display format of the column. Or if you display the query in a form, you can choose the formatting of the field in the Control>General>Formatting option.
If you are using an external database, then you may be able to use the FORMAT command but the format may not show in the query table or forms without separately setting the display format in those locations.