You'll need MID(parentstr,firstnum,(lastnum-firstnum))