devxlogo

Including Single Quotes in Queries

Including Single Quotes in Queries

Question:
How do you include a single quotation mark in a query?Example:

“Select * From BATCH Where BATCH.NAME = ‘O’Connel'”

Answer:
Simply replace the single quote with two single quotes together. Since most databases (if not all) use single quotes to delimit strings, you have to put two of them together to represent a real single quote.

devx-admin

Share the Post: