>hi, how I can do so that in select SQL to be able to fill with zero from the left, in vfp is with the function right(), but SQL this does not work to me.
>ej.
>select STR(E.anomat,4)+'-'+RIGHT('0000'+RTRIM(STR(E.numest)),4) as matricula
>the field registers must contain matricula=2005-0045, but 2005- 45
Try with
select STR(E.anomat,4)+'-'+PADL(E.numest,4,"0") as matricula
_______________________________________________________________
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