Re: Ace report select statement trbl

Posted in 1997

Alan Denney — Thu, 16 Oct 1997 08:08:32 GMT — source: Informix-list mailing list archive (1991-1998)

In article <3445A987.D21@execpc.com>, |ichael Hammernik <mhammer@execpc.com> 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*" I suspect you want "not matches" rather than "!="...