How to escape a string with a quote on the end

Question

Does somebody know how to escape the following quote within the string correctly?

PDM-40-100'

The string has an quote on the right end.

Use [sql-parameters](https://stackoverflow.com/questions/542510/how-do-i-create-a-parameterized-sql-query-why-should-i) — Tim Schmelter, Mar 26 '21 at 13:43
Post more code of where your attempt at using this string is going wrong — Caius Jard, Mar 26 '21 at 14:25

score 1 · Answer 1 · answered Mar 26 '21 at 14:00

1

In SQL escaping (') can be achieved with (''). User PDM-40-100'' instead of PDM-40-100'.

If varX= PDM-40-100' then you can use Replace(varX,"'","''")

answered Mar 26 '21 at 14:00

Please let us know if you are facing any more difficulties with this query. – Kazi Mohammad Ali Nur Romel Mar 28 '21 at 20:25

score 0 · Answer 2 · answered Mar 26 '21 at 13:54

0

This is a sample for 1 string. With this logic, you can escape all rows in table.

Declare @string as varchar(12)='PDM-40-100'''  
Select left(@string, len(@string)-1)

answered Mar 26 '21 at 13:54

Marko Ivkovic

2 Answers2