In SQL, if you need to include a single quote as part of a string, simply write two consecutive single quotes in its place.

Name: In SQL, if you need to include a single quote as part of a string, simply write two consecutive single quotes in its place.
Brand: Quizplus
Rating: 4.7 (44 reviews)

Question

Quizplus · Accepted Answer

This is true in SQL. For example, if you need to include the string "It's nice" in a SQL statement, it would be written as "It''s nice".

In SQL, If You Need to Include a Single Quote