The select statements in the examples thus far produce results showing data in the database. You can also write queries so that the results contain strings of j9[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)
