Split String

Question

Hi friends , In my database i have a column named "Name" in this column i had stored firstname and lastname with '_' seprator. Ex : "XYZ_ABC". But now in my select query i would like to have only lastname to fetch. For that what should i do? How to splite the value in select query ? Waiting for the reply. Thank you.