sum(dec(substr(myfield, 1, 9), 9, 0) / 100)