>Thank you Sergey - it works. Have you any idea how to PAD() a field length in a SELECT statement? As in select a,b,c,PAD(d,25). Adding the PAD() there gives an error - is there any way of adding to the length of d in the cursor the data is put into?

Actually, that's a safer way to ensure length, as Fox will judge the length of an expression with variable length by the first record, which will probably be too short. PadR() is the best choice, or "cast(... as c(25)) as OutputFieldName". The "as name" part is very handy because otherwise you may get exp_1 or some such meaningless name.