Thanks so much Mark.  I ended up using a vairation.  Thanks for pointing me in the "right" direction.

substring(right(i.Type,CHARINDEX('-', reverse(i.Type))), 2, 20) as Category

Terry  

Thanks Mark,

I get the following error when running the above statement:

Server: Msg 536, Level 16, State 1, Line 1

Invalid length parameter passed to the substring function.

Doesn't like the -1 in...