In-DB Formula - SQL

[L_T]

Hi All,

I have an SQL database and need to modify an existing column to remove all apostrophes from the strings. I am trying to use a formula in-DB, however I keep getting an error message. 

If I were to use a formula tool, the expression would be 

existing column: [abc]

[abc] --> replace([abc], "'", "")

Seems like I am doing something wrong with the SQL syntax, so any help would be appreciated!

Thanks  

[Christina_H · Accepted solution]

With some trial and error, I got this to work to replace / with _

replace("abc",'/','_')

The field name needs to be in double quotes, and the strings to find and replace in single quotes.  In your case, since you're searching for single quotes I think you'll need 4 single quotes:

replace("abc",'''','')