Agnes,
>I have no account on Foxpro advisor. ::(
Sounds like it is time to get out and make some friends. ;-) But seriouly, maybe it will be helpful information to some other reader. It sounds like you understand the solution.
>
>Anyway, the view 'designer' is something to do very first steps on SELECT SQL. To much limitations. (O.k. I'm a purist. I don't like designers, I like code.)
>
One thing brought out in the magazine is that you would expect the VFP 8 View Designer to accept an expression using the 'Is True' criteria, but it doesn't.
Actually, it was this thread that made me realize that this was the solution to a problem I was having myself. I didn't realize it even after reading the magazine. So, thank you to Carlos and Doru!!
Mike