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.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

More From DevX