Removing part of character of filename MSSQL

sql remove part of string in column
sql remove everything before a character
sql remove everything after a character
sql remove characters from string right
sql remove specific characters from string
sql select everything before a character
sql remove characters from string left
sql select everything after character