the following will return all the values you specified.

select ename from emp where lower(ename) like 'krishn%';

If you want this statement to use an index, you have to create a function based index.

Robel