I have an SQL select query that's grabbing some data from my database. I need to replace a certain word that contains a semicolon in my select query. Exactly this:
REPLACE(Table.Field,'"','') AS Field1
The error I'm getting reads
Unclosed quotation mark after the character string '"'.
So I think the semicolon is terminating the query. How can I escape that semicolon?
I tried backslashes and using double quotes.
Aucun commentaire:
Enregistrer un commentaire