You can write queries so that the results contain strings of characters. Enclose the string in single or double quotation marks, and separate it from other elements in the select list with a comma.
Use double quotation marks if there is an apostrophe in the string—otherwise, the apostrophe is interpreted as a single quotation mark.
Here is a query with a character string:
select "The publisher’s name is", Publisher = pub_name from publishers
Publisher ------------------------ -------------------- The publisher’s name is New Age Books The publisher’s name is Binnet & Hardley The publisher’s name is Algodata Infosystems (3 rows affected)