Query Sql Server in String

Question

I want to assign the result of a SQL Server query to a variable. This query may or may not have more than one line, but only one column.
Example:
QUERY> SELECT NAME FROM NAMES
OUTPUT

 NAME

Michael

Michele

John

James

 

Variable > String names = ('Michael','Michele','John','James');