Subject Re: [firebird-support] leading and trailin zero in select statement
Author Gabor Boros

LPAD/RPAD is not a solution for you?

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


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...