>Then I add all the parts of the SELECT and send the statement to the SQL server. If I'm doing local data I use macro expansion: &cMySQLStatement.
yupyup... done there been that too.
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos