How and when to use LIKE statement ?

Like will be use when search records i.e start with, end with, contains a particuar character in string as

1. start with 's'
select * from emp where empName like 's%'
2. end with 's'
select * from emp where empName like '%s'
1. contain 's'
select * from emp where empName like '%s%'