Thank this author by sharing:
By Jacob Sebastian,
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
We need to find the first occurrence of character ie non numeric data in the string ...
Comments posted to this topic are about the item [B]TSQL Challenge 46 - Remove leading occurrences o...
Remove characters matched in a patindex pattern recursively.
How to replace first occurrance of pipe delimeter
Remove characters from numbers