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'. It doesn't support REGEXP like MySQL right? _______________________________________________ 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>
