Help with SQL Syntax
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 !=
Thanks for any help.
--
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Harold Sasaki
hsasaki@harold.com
http://www.harold.com/