Re: just going with LIKE

* Ross <ross@aztechost.com>: > Had a look at it and much easier to use LIKE with wildcards. Was unsure > whether the query was case sensitive that is why I asked. Missed the earlier post, so I don't know if you're using MySQL or not (other responses indicate you probably are). If you are, REGEXP in mysql works quite nicely, and are relatively fast (though not as fast as LIKE) when going through smaller sets of records -- I wouldn't use it for large sets of records, however. -- Matthew Weier O'Phinney | WEBSITES: Webmaster and IT Specialist | http://www.garden.org National Gardening Association | http://www.kidsgardening.com 802-863-5251 x156 | http://nationalgardenmonth.org mailto:matthew@garden.org | http://vermontbotanical.org