Hi,

LPAD/RPAD is not a solution for you?

In example: SELECT LPAD('12',5,'0') FROM RDB$DATABASE

Gabor

majstor írta:

> Hi,
>
> I have small problem, when I need to ad some extra text or leading or trailin zero numbers into my result of select sql statement in firebird. For now I solve this with some procedure on client app, but I need to do this with select statement.
>
> for example I have a document ID 'X01-FDDA-001234' and next document id will be same as this just at the and on word wil be 001235! So is there any solution in firebird to solve this problem?
>
> Thanks in advanced...