Stonefield Query had the functionality to do this. Although I am not sure if you can buy it any more. You might want to check with Stonefields web site.

BOb



>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