On Sun, Aug 22, 2010 at 15:48, Marco Castro wrote:
> You mean that "\%" is a convertion of % to \% done by Dot.Net not by the
> provider, correct?
No. If you look at Contains method signature, it's about string to
match, not pattern. Hence the % escaping. It's by definition. If
you'll try Contain
>>
>> ...WHERE UPPER("Extent1"."CLIENTNAME") LIKE _UTF8'%MARC\%VIEI%'
>> ESCAPE
>> _UTF8'\'
> No, you can't do it with Contains. The Contains takes a string, not a
> pattern, it's how the method signature is done. But you can do it
> using i.e. StartsWith and EndsWith together.
>
You mean th
