SQL query to get the string before or after any specific character (Substring, Charindex)

Nice explanation

Thank you so much for the great example! Once thing I noticed - I don't think you need the -1 in the 3rd select. If you leave it off it would display the entire last part of the field which in this example is 'com'

Is there a way to pull a word that falls in between ‘Type:’ and ‘Cuff:’

Subscribed!!!! Thank you for your explanation! Gonna check your other SQL videos!