I understand your problem,
You can try this query to fetch your data,
select * from tablename where name like 'S%I';
The query will work like,
First, it will take all the names which will have 'S' as the First letter and then It will check for the last letter 'I' and then it will show the result.
I hope this answer will help you,