you might want to check if the problem is being caused by case-sensitivity issues. try converting your search parameter to either all-uppercase or lowercase and converting your sql to use the LCASE or UCASE functions . e.g. :

select * from table where ucase(name) like '%name%'
[download]

hth