select reverse(substring(reverse(colname),2,charindex('a',reverse(colname),2)-2))
from yourtable