How to calculate number of occurances of a character in a string
Is there a string function in T-sql which tells us that the number of occurances of a character in a string? eg. abracadabra no. of a's in the string : 5 Any Help is appreciated.select len(@.YourString)- len(replace(@.YourString, 'a', ''))
No comments:
Post a Comment