Actually, it's not the SQL that is truncating the field names. You are putting your results into a free table which only allows field names to a max length of 10.

Definitely look at using views. Once you get into it you'll see how much easier it is for you.

>I found the problem...It seems that SQL truncates fieldnames to a length of 10 characters. I had some fields longer than that so on update, it did not match.
>
>I've never used views but I think I ought to get round to it eh?
>
>Thanks again,
>
>Mark