ORACLE/SYBASE SQL Clarification@uergen d : this one helped me. but how can i modify the same to retrive the characters after _ symbol eg : 12123454_aa -> aa in this case 1545454_a -> only a in this case