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