This challenge is a slightly enhanced version of the 'remove leading zeros' problem. The 'remove leading zeros' problem involves removing all the occurrences of the leading zeroes from a number. What makes this challenge different is the requirement to remove the 'leading' occurrences of the first character in the string. So in this challenge, it is not zeroes that you are looking for, instead the first character in the string should be searched and all the leading occurrences should be removed.
TSQL Challenge 46 - Remove leading occurrences of the first character in a string