SQL returns no records, but should

[Scott Runkel]

Hi,

Does anyone know why the following would return no records? I for a fact there 
are records with the phrase "most likely" or "MOST likely" in them.

SELECT *, recid FROM main WHERE (item_text like '%MOST likely%' OR answer_text 
like '%MOST likely%' ) ORDER BY item_num

There's obviously just some little thing I'm missing. I'm using Val 2 and 
Director MX 2004. Case-sensitivity is off.

For comparison, the following returns plenty of records:

SELECT *, recid FROM main WHERE (item_text like '%MOST%' OR answer_text like 
'%MOST%' ) AND (item_text like '%likely%' OR answer_text like '%likely%' ) ORDER 
BY item_num

-SR

Scott Runkel
Director of Technology
Hypix Media, Inc.
503-722-2123