Sql to count a set - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Sql to count a set

Author

Topic

despy1
Starting Member

1 Post

Posted - 2007-05-30 : 12:20:03

How can I find out how many items are in a set?

So for example a statement like select count('a','b','c','d') which would return four for the number of items in there

Thanks

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-05-30 : 12:47:40

what do you mean by "set"? do you mean a comma separated list of values in a string? if so check this:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=CSV,Splitting%20delimited%20lists,Best%20split%20functions

www.elsasoft.org

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources