Hi Denise,

>Having the always true condition in there just saves me from having to figure out later where I need to put a where.

I usually use something like this:

  lcWhere = ""
  IF some condition
     IF NOT EMPTY(m.lcWhere)
        lcWhere = m.lcWhere + " AND "
     ENDIF
     lcWhere = lcWhere + "some condition"
  ENDIF
  IF NOT EMPTY(m.lcWhere)
     lcWhere = "WHERE " + m.lcWhere
  ENDIF
  SELECT fields FROM table &lcWhere INTO...

Christof