I have a database called: "test.fm"
I have two text fields: "name1" and "city"

I made one record:
name1 = rich
city = winnipeg

The following queries give me the following results (just prints the data):
    select * from \"test.fm\" where name1 = 'rich'
    select * from \"test.fm\" where name1 = 'rich' or name1 = 'blank'
    select * from \"test.fm\" where name1 = 'rich' and city = 'winnipeg'

RESULTS:
name1: rich
city: winnipeg


Here are the queries that don't work. They return no results at all.
    select * from \"test.fm\" where name1 = 'rich' or name1 = 'blank' and
city = 'winnipeg'
    select * from \"test.fm\" where (name1 = 'rich' or name1 = 'blank') and
city = 'winnipeg'

This should definitely work. Any ideas, I really need help on this one.


Richard