How to count instances of character in SQL Column

by

This snippet works in the specific situation where you have a boolean: it answers “how many non-Ns are there?”.

SELECT LEN(REPLACE(col, 'N', ''))

If, in a different situation, you were actually trying to count the occurrences of a certain character (for example ‘Y’) in any given string, use this:

SELECT LEN(col) - LEN(REPLACE(col, 'Y', ''))

More Related Contents:

  1. How to split a single column values to multiple column values?
  2. Better techniques for trimming leading zeros in SQL Server?
  3. How do I remove extended ASCII characters from a string in T-SQL?
  4. Count Returning blank instead of 0
  5. Calculate a Running Total in SQL Server
  6. How can I do an UPDATE statement with JOIN in SQL Server?
  7. Not equal != operator on NULL
  8. SET NOCOUNT ON usage
  9. How can I get column names from a table in SQL Server?
  10. How can I select the first day of a month in SQL?
  11. Is it possible to specify condition in Count()?
  12. WHERE Clause vs ON when using JOIN
  13. how can I Update top 100 records in sql server
  14. @@IDENTITY, SCOPE_IDENTITY(), OUTPUT and other methods of retrieving last identity
  15. How To Create Table with Identity Column
  16. What’s the best to check if item exist or not: Select Count(ID)OR Exist(…)?
  17. SQL count(*) performance
  18. SQL query to find Nth highest salary from a salary table
  19. How to calculate the number of “Tuesdays” between two dates in TSQL?
  20. How to split string using delimiter char using T-SQL?
  21. Get the records of last month in SQL server
  22. I want to use CASE statement to update some records in sql server 2005
  23. alternatives to REPLACE on a text or ntext datatype
  24. How to return a incremental group number per group in SQL
  25. Cumulative Total in MS Sql server [duplicate]
  26. Why is RAND() not producing random numbers?
  27. SQL Server equivalent of WM_CONCAT function [duplicate]
  28. Distributed transaction error?
  29. Should every SQL Server foreign key have a matching index? [closed]
  30. Determine what user created objects in SQL Server

Leave a Comment