Escape Single Quotes in SQL

Escape Single Quotes in SQL

Single Quotes in Select , Insert and Update SQL statement can be escaped by adding another single quote in front.

Example :

1. Select 'My baby''s name is Naman';

Note : Notice extra single quote in baby''s

2. Insert into Employee ( Id , Name ) values ( 1,'O''Connor' )

Note : Inorder to insert name O'Connor in SQL table an extra single quote was added ( O''Connor )