Hi Donald,

>The problem I've got with this particular string is the last "and" clause. I keep getting syntax errors.

Sometimes VFP has problems if you insert a line break into a string. Use something like

Query = "....."+;
"......"+;
"......"

instead.

Christof