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.