Replace in SQL

TimWells Member
edited March 2023 in SQL DataFlows

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`, '[', ' '), ']', ' ');


But it isnt working. 


Can anyone assist?