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', ''))
blindman
Showing posts with label stringeg. Show all posts
Showing posts with label stringeg. Show all posts
Subscribe to:
Posts (Atom)