asked on
T-SQL select output to string
what is the quickest way to have the resultset (multimple records, one field) of a SELECT statement be formatted into one string?
SELECT
name
FROM
tblCity
WHERE
state = 'CA'
Microsoft SQL Server 2005SQL
Last Comment
Reza Rad
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
another way:
SELECT
name+',' AS cities
FROM
tblCity
WHERE
state = 'CA'
FOR XML PATH ('')
I'm guess, you want the select multiple fields from a conditional select statement and have the returned result 1 string but your code snippet is confusing.
Let us know.