i have a column which is varchar(20) and has a text like this:
As you can see, the text has 3 parts the one before +, the part in between the two +es and the last part after the second +
what i want do so is, i want to get the first and last parts, and rejoin them
please note that none of the parts have fixed lengths. the only constant we have is that definitely there will be two + es.
is there a ways to get my requirement ?
Thanks in Advance
View Complete Post