sql query for sub string no of charter lenth data pic

SELECT SUBSTRING(event_title,CHARINDEX(N'Þ',event_title),5) as [String] from events

result -thank

sql query for sub string no of charter lenth data pic