You may use the HSQL function

TRUNCATE to meet your needs. As an FYI ( For Your Information ), this function works both with

HSQL Version 1.8 and

HSQL Version 2.?HSQL Documentation wrote:

TRUNCATE

TRUNCATE ( <num value expr> [, <int value expr>] )

Returns a value in the same type as <num value expr> but may reduce the scale of DECIMAL and NUMERIC

values. The value is rounded by replacing digits with zeros from <int value expr> places right of the decimal

point to the end. If <int value expr> is negative, ABS( <int value expr> ) digits to left of the decimal

point and all digits to the right of the decimal points are replaced with zeros. Results of calling TRUNCATE with

12345.6789 with (-2, 0, 2, 4) are (12300, 12345, 12345.67, 12345.6789). The function does not change the number if

the second argument is larger than or equal to the scale of the first argument.

If the second argument is not a constant (when it is a parameter or column reference) then the type of the return value

is always the same as the type of the first argument. In this case, the discarded digits are replaced with zeros. (JDBC)

So, for example, run the following Query to see how it works:

- Code: Select all Expand viewCollapse view
`Select `

INFORMATION_SCHEMA.SYSTEM_TABLES.TABLE_NAME,

TRUNCATE(123.4567, 2) as "TRUCNCATE_123.4567",

TRUNCATE(123.45, 2) as "TRUNCATE_123.45",

TRUNCATE(123.4, 2) as "TRUNCATE_123.4",

TRUNCATE(123, 2) as "TRUNCATE_123",

TRUNCATE(.456, 2) as "TRUNCATE_.456",

TRUNCATE(0, 2) as "TRUNCATE_0"

From INFORMATION_SCHEMA.SYSTEM_TABLES

Where INFORMATION_SCHEMA.SYSTEM_TABLES.TABLE_SCHEM = CURRENT_SCHEMA

Order By UPPER(INFORMATION_SCHEMA.SYSTEM_TABLES.TABLE_NAME) ASC

I hope this helps, please be sure to let me / us know.

Sliderule

Thanks to add

[Solved] in your

1st post Subject (edit button top right) if this issue has been resolved.