charindex until not number code example Example: reutrn string after character sql select right(col, charindex('-', reverse(col)) - 1)