On Sun, Aug 22, 2010 at 15:48, Marco Castro <mcas...@mcsoft.com.br> 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 Contains on collection of objects in memory, it'll not work too. Why it should behave differently in database? > The situation of LIKE '%MY%DATA%CORRECT%' wont work with StartsWith and > EndsWith! Then you need to use another approach. -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com ------------------------------------------------------------------------------ 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