Ask Your Question

Base: Format numbers in queries [closed]

asked 2013-11-30 22:09:29 +0100

Amir Karimi gravatar image

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.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-11-15 07:24:36.295175

1 Answer

Sort by » oldest newest most voted

answered 2013-12-02 00:29:50 +0100

w_whalley gravatar image

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.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-11-30 22:09:29 +0100

Seen: 1,315 times

Last updated: Dec 02 '13