O'Reilly logo
  • Dustin Waybright thinks this is interesting:

This section covers a couple of items that are specific to character data: proper form of literals and the LIKE predicate.

From

Cover of Training Kit (Exam 70-461): Querying Microsoft® SQL Server® 2012

Note

Literals are data surrounded by single quotes ''