Count the number of results in a seperated list

Question

I know I could probably just count the commas but I wanted to know if theres a built in way to count the results in a comma seperated list?

e.g

DECLARE @IDs NVARCHAR(100)
SET @IDS = '2,3,54,234,'

SELECT
  COUNT(value FROM STRING_SPLIT(@IDs)) AS [Count]
FROM
  Table

user_13302 · Answer

Try this:

DECLARE @IDs NVARCHAR(100)
SET @IDS = '2,3,54,234,'

SELECT
    COUNT(*)
FROM 
    STRING_SPLIT(@IDs, ',')