SELECT name FROM tblCity WHERE state = 'CA'
Select allOpen in new window
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.