Is there support for the ANS LIST Statement in SQL Server?

We are considering moving our application to MS SQL Server from another
database. When I have looked at the documentation I do not see any support
for the ANS LIST statement. (This is an aggregate like function which
allows for concatenation of String Results with Separators (e.g. creates a
string containing a list of items matching the WHERE clause separated by the
designated separator) ).
This is very handy and we use this frequently. IF SQL Server does not
support this feature, how could I implement an equivalent?
Thanks
Glenn Barber
You can do this very easily with the RAC utility/tool for S2k.
No sql coding required.
For info on concatenation over rows see:
http://www.rac4sql.net/onlinehelp.asp?topic=236
RAC v2.2 and QALite @.
www.rac4sql.net
|||Thanks - I don't know much about RAC. - Is this a proprietary product - or some publically available utility built with with SQLServer SP's? I will investigate it.
As a software publisher there are lots of considerations for us and our customers when straying outside of the vendor's supported syntax. It would be much easier if the ANS LIST syntax was directly supported.
I'd still like to know if the LIST command is supported or planned to be supported in a future release.
|||It is not there and I have not seen it in the planned feature list for the next version (which is still a year
away, though). I suggest you vent your need through sqlwish@.microsoft.com.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Glenn Barber" <anonymous@.discussions.microsoft.com> wrote in message
news:A1F44D8D-E0AA-42C9-AF7F-B2A8A48829F1@.microsoft.com...
> Thanks - I don't know much about RAC. - Is this a proprietary product - or some publically available utility
built with with SQLServer SP's? I will investigate it.
> As a software publisher there are lots of considerations for us and our customers when straying outside of
the vendor's supported syntax. It would be much easier if the ANS LIST syntax was directly supported.
> I'd still like to know if the LIST command is supported or planned to be supported in a future release.
|||Thanks Tibor
I will definitely send my request to the wishlist.
Is there an efficient way of creating an equivalent function in a Stored Procedure?
Glenn