I want to cast number to varchar and fill the leading characters with
zeros. In oracle I can do "to_char(25, '0000')" and get as result
"0025". Is there any similar solution for this in firebird?
(If I just cast number to varchar (cast(25 as varchar(4)) I get char
"25").

Thanks for answer.

Matej