may be I am missing the point but for your query I would use --

WHERE UPPER(name) LIKE 'K%'

This, however will not make use of the index because of the function call on the column itself. But it will return what you want? won't it ?

- Rajeev