Character Strings in Query Results

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 
------------------------      --------------------
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)