-----------------------------------------------------------
New Message on BDOTNET
-----------------------------------------------------------
From: laks_win
Message 2 in Discussion
Hi,
U can use COALESCE or ISNULL.
SELECT * FROM Member
DECLARE @NameList VARCHAR(200)
SELECT @NameList = ISNULL(@NameList,'') + UserName FROM Member
PRINT @NameList
DECLARE @NameList VARCHAR(200)
SELECT @NameList = COALESCE(@NameList,'') + UserName FROM Member
PRINT @NameList
But here is the limitation, yes we cannot use on the fly in the SELECT query.
The name list need to be stored in a variable (@NameList), and can be used. If
u want to use in the query as a column, then u need to create a function(UDF)
and can be used.
Ex:
CREATE FUNCTION NameList()
RETURNS VARCHAR(200)
AS
BEGIN
DECLARE @NameList VARCHAR(200)
SELECT @NameList = COALESCE(@NameList,'') + UserName FROM Member
RETURN @NameList
END
SELECT dbo.NameList() As NameList
Hope this helps.
Regards
Lakshmi Narayanan.R
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/bdotnet/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
