>How about:
>

>SELECT * FROM tblAbc WHERE DTOS(trans_date) => '20061121' AND DTOS(trans_date) <= '20061127'
>

>You query Date field and compare it with string, not allowed :o)

The statement I used in my question is eligible and works fine in the SQL.
DTOS is a Fox function - will be not recognized in SQL ;<