Search results

I have a simple select query , and I want to add a field that will take the value from another field and increment it based on a condtion. i know i need a case statement but not sure how to go about this .. column 4 is my desired result i want to increment the text string from column 3...