On 8/23/06, Chris Price <chris.price at choctaw.co.uk> wrote: > I'm running a query in my table to find a field which contains a > certain word so I'm using 'like', e.g. select * from table where field > like '%thisWord%'. > > But it doesn't find 'ThisWord' or 'thisword'. > > Is there a simple way to get round this capitalisation issue? select * from table where UPPER(field) like UPPER('%thisWord%') -- Eduardo Bacchi Kienetz LPI Certified - Level 2 http://www.noticiaslinux.com.br/eduardo/