Hi Gabor,

That is what I need, thanks for help.

--- In firebird-support@yahoogroups.com, Gabor Boros <gaborboros@...> wrote:
>
> 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...
>