John,

>It's splitting the line, probably, because you have some hard returns in the >memo fields. Try using STRTRAN(memofield,CHR(13)," ") to replace them with >spaces instead of just memofield.

Yep. You're right. I'd used CHRTRAN to get round this but hadn't realised it didn't apply to memos. Thanks.

>Also, a point of personal preference: I'd use UPDATE &cUpdParms rather than >&lcWholeCommand.

Agreed. I was working from memory and my code does actually say UPDATE &cUpdParms.

Thanks again.

Paul