>Hi,
>
>I wonder can i declare a ARRAY variable in SQL Server? if so, then how?
>
>
>Many Many Thanks
>Aston

Try

create table #mydata

(which is really a temp table, sorry no arrays)

I would love to see arrays or strucutures added to SQL... it is one of the major things that is missing.

Of course, with SQL server 2000 you may be able to create a function that emulates an array, but I am still working with 7.0.

BOb