Hi Richard, I am afraid, there no such option unless you want to hack the sql compiler :)
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 > -- ====================================== Syed Haider. EMBL-European Bioinformatics Institute Wellcome Trust Genome Campus, Hinxton, Cambridge CB10 1SD, UK. ======================================
