"like" not working

[FRED_EMMERICH_(Guest)]

In my filter (SQL 12.5) I use the "like" operator on one of my database fields. My data that I want is this:____ENCANA OIL AND GAS____so I did: "like" ENCANA____but it gives me no results. I would have expected "like" to mean "starts with" or "contains". So now I am not sure what it means??? ____thanks__Fred Emmerich

[kfleming]

You need to surround the text with wildcard characters for LIKE to work.__Example:____*ENCANA*____Kathleen__R&R Support