>George,
>
>What I am looking for is a utility to help create SQL statements.
>
>Any ideas?
>
>Rex

Would query or View Designer in VFP be suffiecient? If it's a view, you can create draft in View Designer, then modify with EView (available here for Download).
>
>>>All,
>>>
>>>I am looking for a utility which returns a string to be used in the WHERE clause of a SQL statement given a list of tables in a database. I think it can be done from the relation objects in the DBC.
>>>
>>>Has anyone seen/written anything like this?
>>>
>>>TIA
>>>
>>Rex,
>>
>>CURSORGETPROP() with SQL as the property will return the complete SQL statement. From there it shouldn't be too hard to parse out the WHERE clause.