Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

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 -

View this thread on the forum...