Posted onOctober 27, 2010 by Josephine Select part of a character string based on a character REVERSE(LEFT(REVERSE(@myString),CHARINDEX(‘>’,REVERSE(@myString))-1))