On Jul 15, 2006, at 10:03 PM, Long Huynh wrote:
I would like to build a SELECT query that find any
thing begin with ...
SELECT product, cproduct FROM product WHERE product LIKE 'Gin%'
But it returns nothing, when I have a lot of products begin with
'Gin'.
It work with this clause " product LIKE '%Gin%', but this give me
everything that contain 'gin'.
Does it give you ones that start with Gin as well ?
If so that suggests that those you think start with "gin" don't and
may have spaces or some other non-prinatble leading characters
It doesn't support REGEXP like MySQL right?
No
_______________________________________________
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>
