Try something like....

REPLICATE('0', (4 - LEN(E.numest))) + E.numest

HTH

Chris

>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