• Koen Verbeeck (1/8/2013)


    You can reverse the string, look for the position of the second underscore and take the substring starting from that position till the end. Reverse the substring back and you have your result.

    edit: or don't reverse the string and look for the fourth underscore, if the first part keeps the same structure.

    Thanks SScrazy.

    Can you please send me the query?

    Regards

    SqlStud