count the number of spaces in values in sql server
sql-server, sql-server-2008
Solution
SELECT LEN(column1)-LEN(REPLACE(column1, ' ', '')) FROM YourTableName
Problem
I need the number of spaces in column values in sql server. Ex: ``` column1 ------------ aaa bbbb - 1 space aaa bbb ccc - 2 space aaa bbb ccc ddd - 3 space ``` I need the count of spaces like this. thanks.