[[https://www.revelation.com/|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: ===
 
{{tag>"OpenInsight Specific"}}
 
<QUOTE>
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
</QUOTE>
----

=== At 01 NOV 1999 05:32AM Oystein Reigem wrote:  ===

<QUOTE>Tony,



[i]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?[/i]



What about one of the following?:



[b]=EXU[/b]

[b]EXT_[/b] (use some other character if "_" is not high enough in collation sequence)

[b]EXT
[/b] (dodgy, but seems to work here.)



- Oystein -





</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=C65647CA6548303F8525681B003E7D2E|View this thread on the  forum...]]