Array in SQL Server

How would one implement an array in SQL Server ?
Specically, i'm parsing a field into the array, and doing operations on these elements.
Thanks.use a temp table instead?|||You can't...

BUT! If you buy Ken Henderson's book:

"The Guru's Guide to SQL Server Stored Procedures, XML, and HTLM"

Chapter 26 discusses how to fake it out...

http://www.sqlteam.com/store.asp|||come on brett .. why dont you share your knowledge ...

and btw ... i am desperately trying to secure a copy of that book|||Originally posted by Enigma
come on brett .. why dont you share your knowledge ...

and btw ... i am desperately trying to secure a copy of that book

I never did it...had no need, and with table variables it's a breeze...

BUT...I should play with it, just from a learning experience (always move forward, no?)

It entails creating and registering dll's and the like...

I think all the ciode is on the cd that come with the book...

and if you don't have this book, you should by it now, and read it cover to cover...sleep with it...take it out to a hockey game...whatever...

just get it

There are like 6 array function that Ken builds...they let you create, set, get, list, determine the length and destroy the array

He does make mention that you have to be careful...failing to destroy the array will make memory unavailable to the server...