Re: Ace report select statement trbl

Posted in 1997

"Billy Wheeler" — 16 Oct 1997 07:08:15 -0400 — source: Informix-list mailing list archive (1991-1998)

On 16 Oct 97 at 0:43, Michael hammered away and wrote: > I'm having a problem with a portion of a select statement in writing > an ace report in Online 5.0. I'm letting the user specify a field > but when he chooses * for all I want to keep one element of that > field from appearing. My statement reads > > where message_type = $message_type > and message_type != "DTA*" Try and message_type[1,3] != "DTA" or and message_type NOT MATCHES "DTA*" HTH. -- Ciao, Billy Nose to the ear in Johannesburg -- Murder City never looked so good! Get the Informix FAQs of life at http://www.iiug.org/techinfo/faq/faq_top.html Need to get some drivel into your life? http://www.west.co.za/tasteless/