Francois,
I must admit, I don't know all the ANSI standards for SQL-SELECT's and if you say FOX's implementation is weak, then I must take your word for it. That being the case, you probably have a good point. I know that improvements were made for 5.0, but apparently not enough.
Matt
Matt McDonnell
...building a better mousetrap with moldy cheese...