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

Bhuvanesh Mohankumar · Answer

Please try this SELECT SUBSTRING (@TextCHARINDEX( 'theworld' @Text) CHARINDEX( 'immediately' @text)-CHARINDEX( 'theworld' @Text)+Len( 'immediately' )) Mark as answer if helpful.