How do you count the number of occurrences of a certain substring in a SQL varchar?

by

The first way that comes to mind is to do it indirectly by replacing the comma with an empty string and comparing the lengths

Declare @string varchar(1000)
Set @string = 'a,b,c,d'
select len(@string) - len(replace(@string, ',', ''))

More Related Contents:

  1. Update a table using JOIN in SQL Server?
  2. Comma separated results in SQL
  3. T-SQL stored procedure that accepts multiple Id values
  4. Understanding PIVOT function in T-SQL
  5. Calculate running total / running balance
  6. How do I escape a percentage sign in T-SQL?
  7. Using RegEx in SQL Server
  8. List of all index & index columns in SQL Server DB
  9. Why use a READ UNCOMMITTED isolation level?
  10. How much size “Null” value takes in SQL Server
  11. SQL Server: Isolation level leaks across pooled connections
  12. Create a view with ORDER BY clause
  13. INSERT INTO vs SELECT INTO
  14. How do I use the CONCAT function in SQL Server 2008 R2?
  15. Possible to store value of one select column and use it for the next one?
  16. How can sanitation that escapes single quotes be defeated by SQL injection in SQL Server?
  17. How do I exclude Weekend days in a SQL Server query?
  18. EXEC sp_executesql with multiple parameters
  19. Preserving ORDER BY in SELECT INTO
  20. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  21. Can you call a webservice from TSQL code?
  22. How to add custom attributes to SQL connection string?
  23. Multiple Column Pivot in T-SQL
  24. Joining multiple tables returns NULL value
  25. Which join syntax is better?
  26. Compute MD5 hash of a UTF8 string
  27. LPAD in SQL Server 2008
  28. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  29. How do I remove non-breaking spaces from a column in SQL server?
  30. What are row, page and table locks? And when they are acquired?

Leave a Comment