devxlogo

Another Way to Fix a Single Quote in SQL Statements

Another Way to Fix a Single Quote in SQL Statements

A generic approach to making sure a single quote (‘) does not cause a SQL statement to fail is to replace the single quote with two single quotes, as in the following example:

 REPLACE(SQL_Statement,

devx-admin

Share the Post: