How to select substring according to CHARACTER INDEX

select serial_num,   SUBSTRING([imagePath],CHARINDEX('a',imagePath),CHARINDEX('g',imagePath)) as column1   from Tbl_EmpDetails order by serial_num asc