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.

Original source

Related problems