Yes, I've tried both single and double quote. I've sure that each field I filter, it has atleast one record begins with 'cool%' or whatever character I want to find. In fact, I look at what's available in the fields first than apply the filter as a test.
However, "%abc%" always work for me, but NOT begins w/. I try this also in the SQLite manager. Thanks --- Jay Wooten <[EMAIL PROTECTED]> wrote: > Silly question but are you using single quotes or > double quotes: > > select product, indications from some_table where > product like 'cool%' > > or > > select product, indications from some_table where > product like "cool%" > > and, just to cover the bases, have you verified > there is data in > the product column that starts with cool ? > > - Jay > > On Jul 18, 2006, at 12:40 AM, Norman Palardy wrote: > > > > > On Jul 17, 2006, at 9:30 PM, Long Huynh wrote: > > > >> I try this, and still did work: > >> > >> SELECT product, indications FROM product p WHERE > >> p.indications LIKE "cool%" > >> > >> but this work > >> > >> LIKE "%cool%", but I only want indications begins > w/ > >> cool. > > > > How are you building the query ? > > Can I see the actual query you send to the > database ? > > Can I see the code you're using ? > > > > The query looks fine and if your database has data > that start with > > cool in the indications column it should be > working > > I do use exactly this kind of code without any > issue in databases > > from RB 5.5.5 using SQLite plugins to current > versions of RB with > > the built in SQLite database > > > > _______________________________________________ > > Unsubscribe or switch delivery mode: > > <http://www.realsoftware.com/support/listmanager/> > > > > Search the archives of this list here: > > > <http://support.realsoftware.com/listarchives/lists.html> > > _______________________________________________ > Unsubscribe or switch delivery mode: > <http://www.realsoftware.com/support/listmanager/> > > Search the archives of this list here: > <http://support.realsoftware.com/listarchives/lists.html> > _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
