List courses with course_id matching pattern with last - delmited token (ie the term in WBCT-1003-030IN-FA2010)

SELECT course_main.course_id, RIGHT(course_id,PATINDEX('%-%',REVERSE(course_id))-1) AS Term
FROM course_main
WHERE course_main.course_id like 'WBCT-%'