I have a query which is throwing an error. Query contains a where clause that looks like this

soTrans.entity = '113950' 
  AND l.id = '80'
  AND shipadd.city = "Coeur D' Alene" 
  AND shipadd.zip = '83815'

The inverted comma in the shippadd.city is causing this error.

Invalid identifier 'Coeur D' Alene', only alphanumeric and underscore characters are allowed.

How will one handle this, in suiteql?

haven't tested it but I think you want

AND shipadd.city = 'Coeur D'' Alene'

that's apparently how you escape single quotes in sql - note I'm not using double quotes for the outer quotes either

It's throwing an error failed to parse SQL. At that specific line.

I used to live in CdA!

What does the CdA abbreviation/slang stand for ? @Eric B

Coeur D' Alene - your problem city 😄

😂😂

You could also use a wildcard?

soTrans.entity = '113950' 
  AND l.id = '80'
  AND shipadd.city LIKE "Coeur D%" 
  AND shipadd.zip = '83815'

I used a wildcard as the temporary solution until Anthony explained how to escape it. I didn't know about string_escape will check it out, thank you.