dimanche 3 mai 2015

How to replace semicolons

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