SQL Server: A Simple Method to Get Specific Part of String

SUBSTRING is a nice function to get a part of string, but when a string consists of many parts, getting specific part of it, is a bit painful task.