>You will have to put a stored Proc in the DBC and pass the "WHERE" clause to that as a parameter via a SELECT SQL. Then your SP can do a RECALL FOR parameter.
>
>SELECT SP_NAME("where_clause") FROM DUMMY_TABLE
>
>Your dummy table need only have 1 or no records and only 1 field.
>

Hi Mark,

SP in a VFP database? I was told that was not possible. This is great news. I've wanted to use them. I'll look into how to use them. Then I can prove to my Boss they are not the spawn of Satan ;-)

Thanks Again
Mike