If I have a table with results like this:
0001400OL
0578400OL
354085OL
48679OL
and if I wanted to replace last characters that end with 400OL to ABC. How would i do that?
this is the select statement that I have, to show all values that end with 400OL probably no use to anyone:
select pcode from innerb where pcode like '%400OL';
this is an expected output:
0001ABC
0578ABC
354085OL
48679OL
JavaScript questions and answers, JavaScript questions pdf, JavaScript question bank, JavaScript questions and answers pdf, mcq on JavaScript pdf, JavaScript questions and solutions, JavaScript mcq Test , Interview JavaScript questions, JavaScript Questions for Interview, JavaScript MCQ (Multiple Choice Questions)