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

# SQL query to get the string before any specific character #
#sql query to get the string after any specific character #
#substring in SQL #
#Charindex in SQL #

[orrjktx]

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'

[sharpazn]

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

[DatDudeBull]

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