>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.