Jose,
be more exact.
What do you wish?
Select data with T-SQL from SQL Server or from Visual FoxPro tables?
>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
_______________________________________________________________
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