Could have been performance related. In which case, why not define a new filter type, 'contains', or something like that?
2008/9/19 Damian Smedley <[EMAIL PROTECTED]>: > On Fri, 19 Sep 2008, Syed Haider wrote: > >> Hi Richard, >> I am afraid, there no such option unless you want to hack the sql >> compiler :) > > I came across the same thing recently. Maybe it would be good to have > something in the SQL compiler to automatically add %'s if the operator is > LIKE (or whatever postgres and ORACLE). I seem to remember there was a > reason we did not do this originally though > >> >> cheers >> syed >> >> On Fri, 2008-09-19 at 15:47 +0100, Richard Holland wrote: >>> >>> Hello. >>> >>> When I make a 'like' filter, I have to type '%' signs into the filter >>> value to indicate the position of the wildcards. >>> >>> Is there any type of filter I can use where it internally >>> automatically adds '%' to both ends of the filter value before >>> searching? >>> >>> In other words, I'd like to have a filter on the page where I can just >>> type a word and it will return me all records containing that word, >>> not just equal to it. >>> >>> cheers, >>> Richard >>> >> > -- Richard Holland, BSc MBCS Finance Director, Eagle Genomics Ltd M: +44 7500 438846 | E: [EMAIL PROTECTED] http://www.eaglegenomics.com/
