Hi

This is called padding.

Simple example (but not what you want you must padd also decimal point)

SELECT LPAD(CAST(100 AS NUMERIC(10,3)), 14, '0') FROM RDB$DATABASE

But you must tell us what is your real problem, as you need padding for what?

Pozdrawiam,

Karol Bieniaszewski