Join Slack
Powered by
<@U01NG3F0YKU> try \ to escape CASE WHEN {customer...
# administration
h
Hemang
06/28/2021, 8:02 PM
@mightyd3
try \ to escape CASE WHEN {customer} = 'Johnny\'s'
m
mightyd3
06/28/2021, 8:54 PM
I did, sadly would error out.
d
David B
06/28/2021, 10:22 PM
oracle - PL/SQL, how to escape single quote in a string? - Stack Overflow
David B
06/28/2021, 10:23 PM
tl;dr: use double apostrophe
CASE WHEN {customer} = 'Johnny''s'
👍 2
Open in Slack
Previous
Next