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>