Replace in SQL

TimWells
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?

Comments