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>

Reply via email to