>Or just
>
>
>select STR(E.anomat,4)+'-'+RIGHT('0000'+ALLTRIM(STR(E.numest)),4) as matricula
>
In this case just^2.
PADL(E.numest,4,"0")
over
RIGHT('0000'+ALLTRIM(STR(E.numest)),4)
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst