how to get first word value from special character string ?

Question

HiHow to get first character from special characters string. for ex. i have below string and want to get first word 'Yes' - ~~~~~~~Yes~~~~~~~~No~No~~~~~~~~~ and also another case is  where i want 'Maybe' - Maybe~~~~~~~~No~No~~~~~~~~~ Is there any approach ? Thanks

Hanook · Answer

This is the query.. DECLARE @str VARCHAR(100)= '~~~~~~~Yes~~~~~~~~No~No~~~~~~~~~' SELECT LEFT( RIGHT(@str LEN(@str)-PATINDEX('%[a-z]%'@str)+1)  PATINDEX( '%[^a-z]%' RIGHT(@str LEN(@str)-PATINDEX('%[a-z]%'@str)+1))-1 ) Just Keep column name instead of @str and add FROM tableName clause at the end of above query... SELECT LEFT( RIGHT(col LEN(col)-PATINDEX('%[a-z]%'col)+1)  PATINDEX( '%[^a-z]%' RIGHT(col LEN(col)-PATINDEX('%[a-z]%'col)+1))-1 ) FROM TableName