select *
from MyTable
where CHARINDEX('73', MyString) = 6

SUBSTRING ( mycolumn ,6 , 2 )

SELECT SUBSTRING(YourColumn,6,2) Result
FROM dbo.YourTable;