In SQL 2005 you can use a trick with FOR XML PATH from the book Inside Microsoft SQL Server 2005: T-SQL Programming

SELECT STUFF((SELECT ',' + Name AS [text()] FROM YourTable FOR XML PATH('')), 1, 1, '') AS NamesList 

>
>In Vfp we can return to Array using SQL statement. Can some body let me know how I can do the same in SQL Server. I have a list that I need to display into a Textbox and the Designer did not let me present the list in the detail band of the report so the next control that allow me to show a list is the textbox in the header band. But then I need to find the way to return 1 record that have the 5 or 10 name of the list.