create table #temp23(color nvarchar(566),item nvarchar(455),size nvarchar(332))

insert into #temp23

select 'red','shirt','for women' union all

select 'green','jumper','for men' union all

select 'yellow','blouse','for girls' union all

select 'black','coat','extra large' union all

select 'blue green','t-shirt','for boys' union...

You mean to say you want to count the occurence of that number right?

If so then below is the query for that:

SELECT (LEN(columnname) - LEN(REPLACE(columnname, FindSubString, '' ))) Cntrepeated

:-)I am...