>@Rick,
>Rick I am afraid your solution, for only spaces and no .NULL. does not work as such since I am not working with text but memo fields.

My solution is Cetin's exact solution except for using NVL() assignment on the fields.

You'll want to cast your field contents to a fixed c(###) length so the values are not truncated if the first record happens to be short compared to other longer records.

I was thinking also on my drive home, Cetin's solution may not work if there is more than one field1, field2, or field3 record for a given group.

I don't have VFP on this computer, but Cetin should be able to give you a new SQL expression. If not, I can give you an XBASE-based solution tomorrow that will work.