Gavin.
With a little fussing the second one worked well.
I didnt realize you could do anything like that in sql with fox.
I still am leery of the m. variables in a cursor it doesnt seem to like to update a select statement.
Thanks for your help it is working, now off to figuring out an ini type file to hold file path values.
Tom
GO Canucks!! (Vancouver Canucks Fan)