QBF - using NOT STARTING (OpenInsight Specific)
At 31 OCT 1999 07:22:32AM Tony Ayling wrote:
I have an urgent request from a client trying to carry out a simple query
THey have several STATUS codes starting EXT and wanta list of all records except the one starting EXT. Using # ]EXT does not work.
Does anyone have a work around please?
Tony
At 01 NOV 1999 05:32AM Oystein Reigem wrote:
Tony,
I have an urgent request from a client trying to carry out a simple query. THey have several STATUS codes starting EXT and wanta list of all records except the one starting EXT. Using # ]EXT does not work. Does anyone have a work around please?
What about one of the following?:
=EXU
EXT_ (use some other character if "_" is not high enough in collation sequence)
EXT (dodgy, but seems to work here.)
- Oystein -