How do I delete automatically the 1st letter of a table field, in Fox Pro?

Question

I want to delete the 1st letter of all the entries of a table. What command should I use in FoxPro?

Also, if someone knows to do that in Excell, it will be easier for me.
Thanks

Answer 1

if u have a filed custname c 40 and u want to delete the first letter

have one more field custname1

then give the following command

repl all custname1 with allt(substr(custname,2,40))

then drop custname and custname1 to custname

in excel have all custnames in cell A1 AND IN A2 USE MID FUNCTION