>>Hmm, now I'm confused. :-) You want to know what SQL is being executed in the C# app?
>
>Bingo. :-)

It's identical to what is being executed in the fox app, totally identical, in fact I extracted the SQL from the C# app into the Fox PRG unchanged.

Kev