SQL uses single quotes (') to delimit strings.What is the standard in order to include a single quote in a String? For example: 'Joe's Burgers'
A)Use double quotes (")
B)Use a normal single quote
C)Use the single quote twice
D)Escape with a (\') as in Java

Question

Quizplus · Accepted Answer

In SQL, the standard way to include a single quote in a string is to use two single quotes in a row (''). This is called escaping the quote. So in this case, the string would be written as 'Joe''s Burgers'. Using double quotes is not standard in SQL, and using a normal single quote would cause a syntax error. Escaping with a backslash (\') is the standard in some programming languages like Java, but not in SQL.

SQL Uses Single Quotes (') to Delimit Strings