morriekken/count_commas.sql

Created June 1, 2022 10:03

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/morriekken/1a511cfed18c6bf49a8229f3c9298be4.js"></script>
Save morriekken/1a511cfed18c6bf49a8229f3c9298be4 to your computer and use it in GitHub Desktop.

Download ZIP

SQL, Count characters (commas) in string

Raw

count_commas.sql

	SELECT
	LEN(col) - LEN(REPLACE(col, ',', '')) count_commas
	FROM table

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