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? MySQL version is 4.1.20 -- Chris Price Choctaw