Replace in SQL
I have a column which is bringing in some field values in between crotchets or square brackets [ ] and also in between inverted commas " " BUT not all values come through like this. I am trying to write a SQL to drop the [ ] and " " in the front and back of the values. im using REPLACE(REPLACE(`COLUMN NAME`, '[', ' '),…
