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