FlameWert/FindTextOccurrence

Created January 9, 2023 17:19

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/FlameWert/99551b1c7ceed2ba9ad8ec420f24453a.js"></script>
Save FlameWert/99551b1c7ceed2ba9ad8ec420f24453a to your computer and use it in GitHub Desktop.

Download ZIP

Find text occurrence in SQL Server

Raw

FindTextOccurrence

	DECLARE @tosearch VARCHAR(MAX)='In'

	SELECT (DATALENGTH(@string)-DATALENGTH(REPLACE(@string,@tosearch,'')))/DATALENGTH(@tosearch)
	AS OccurrenceCount

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment