Yang Jin wrote:

>hello,
> I want to get the same length varchar filed in table from procedure.The content of field is '1', '12 and '123';I want to get ' 1', ' 12' and '123'.I use cast(XX as varchar(3)), but result is dispoint.
> Who can tell me a useful method, TIA!
>
>jinyang
>regard
>
>
>

Firebird 1.5 nows ships with a version of ib_udf that includes
a "lpad" function. That function is exactly what you are
looking for. Take a look in the release notes for details.

Ivan.