>> >> ...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 that "\%" is a convertion of % to \% done by Dot.Net not by the provider, correct? The situation of LIKE '%MY%DATA%CORRECT%' wont work with StartsWith and EndsWith! Thanks ------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider