how to get between two string characters in sqlserver

Question

how to get between two string character 

i will use this query:

 

select * from tbl_type where CategoryId='36' and (type between 'k' and 'r') ORDER BY TYPE asc

 

it show all q to q string but i want its not include "others" string but how please help