I've got a table with a column. I want to change a part of some strings in the column.
Below was the code I tired to execute
select REPLACE(REPLACE(COL, '6|', ''),'-','') FROM Table
the script need to remove '6|' and last character only if it was '-'
Can any one help me to achieve desired output