SQL not accepting my string as a condition in a CASE statement

Question

I am using SQL Server and SSMS.

I am writing a CASE expression in SQL. Here is one of the lines

WHEN [Group] = 'Representation Accepted' AND [Reason] = 'Reduced to Warning Notice' Area Authorised' THEN 31

The issue I am having here is that for the string:

Reduced to Warning Notice' Area Authorised

SQL is getting confused with the quotation mark here and believes it to be the end of the condition and completely omits " Area Authorised". I'm not sure how to solve this issue without removing the single quotation mark. Does anyone know how I cam make SQL accept the entire string with the quotation mark as a condition?.

Double the quote - `'Reduced to Warning Notice'' Area Authorised'`. — jarlh, Jun 27 '22 at 10:51
Is there a way to do it without altering the actual string itself? — , Jun 27 '22 at 10:54
https://meta.stackoverflow.com/questions/388759/why-should-i-tag-my-rdbms — Reporter, Jun 27 '22 at 11:01
There was a solution in the link which I think could have worked also which is to CONCAT the string using the unicode id for the single quote rather than actually typing the character. — , Jun 27 '22 at 12:02

score 1 · Accepted Answer · answered Jun 27 '22 at 10:58

1

use two times single quotation as below

WHEN [Group] = 'Representation Accepted' AND [Reason] = 'Reduced to Warning Notice'' Area Authorised' THEN 31

answered Jun 27 '22 at 10:58

Upender Reddy

568
3
8

SQL not accepting my string as a condition in a CASE statement

1 Answers1