I need to remove a string of words in a column description, but there is no replace.
I am using the following script
set note = replace(note, 'my collection','')
where item_no in (
I am able to remove 'my collection' but I am getting a space in front of the remaining text.
if I replace with NULL it wont work, if I replace ' my collection' with 'my collection'
that should fix it I think