It is most easily understood by looking at a couple of examples.
With text columns, stick to equal to or not equal to, and make sure that any text that appears in the statement is surrounded by single quotes (').