sql server new users: The articles below will help you understand what you can and can't do with a
comma delimited string simulating an array.

Arrays and Lists in SQL Server
http://www.sommarskog.se/arrays-in-sql.html
http://www.realsqlguy.com/?p=9
http://www.aspfaq.com/2248

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf


[quoted text, click to view]

Is it possible to count the number of items from a comma delimited string ?

I select * from table where id IN (parameter)

the parameter is: 18,23,324,34

That is four items, is it possible to count how many items are in the string
? so that the results in the case above results would be : 4 ?

A

here is the way I do it

declare @string varchar(20)
set @string='18,23,324,34'
declare @numberOfCommas int
select @numberOfCommas=len(@string)-len(replace(@string,',',''))
print @numberOfCommas



--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

[quoted text, click to view]

string[] s = parameters.Split(new char[] {','});
int num = s.length;

Good luck with your project,

Otis Mukinfus
http://www.arltex.com