Re: Help with SQL Syntax

In article <4ep3pa$ln@shellx.best.com>, hsasaki@shellx.best.com (Harold Sasaki) wrote: >I'm trying to query a table, but my syntax is not working. Here's >what I'm trying to do: Select all fields where a serial is a certain >number and a field does not match a certain string. > >select * from table where serial = "1" and status not matches "killed"> >Doesn't work for me. Neither does != A pointer indicating what the problem/error is would be good, but if serial is numeric I'd remove the quotes from around the "1". I'd also not call my table, "table", nor my columns "serial" or "status". :-) ------------------------------------,------------------------------------------ Kerry Sainsbury, kerry@kcbbs.gen.nz | THE INFORMIX FAQ v2.4 Oct 95 Quanta Systems, Auckland | http://www.iiug.org/techinfo/faq/ New Zealand. Work: +64 9 377-4473 | ftp://ftp.iiug.org/pub/informix/faq Home: +64 9 279-3571 | ftp://kcbbs.gen.nz:/ftp/pub/informix/