Parsing a string to count 2

[redtoad]

I need to get a count on the number of values in a string.

For instance, my query returns something like this:

'1000,2000,3000'

I need a count of 3 returned (as a varchar). Or if the data returned is '1000', I need a count of 1 returned.

Any help would be appreciated.

 

[swampBoogie]

select len(c) - replace(c,',','') + 1 from t

 

[stravis]

Interesting Solution. However I think you forgot something. I think the code should read as follows

select len(c) - len(replace(c,',','')) + 1 from t

 

[swampBoogie]

Right you are.

 

[redtoad]

Thanks stravis and swampBoogie, that's just what I was looking for.