Liveware Publishing Support Forum

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

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