Hi

Are you looking for something like this

select ename from emp where upper(ename) like upper('KriS%');

here upper fuction will convert everything to upper case

I Hope this is what you are looking for

Regards