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>
