How to pull information from a string in SQL

[KAMAZON]

Hi guys,

My SQL query writing isn't that great so I'm practicing new methods that are relevent to my work. I have imported a table that has non standard information such as:

Hi hi I'm a stupid face and my fav table is <ORLY> but I like chocolate.

or

Hello this is a <Table_name> and i'm just dandy

in other words, there's no real relation between the strings, except that information i want to pull out is between < >. Can someone suggest a method to pull out that information only? I am thinking CASE or SUBSTRING? The problem I have with substring is that the # of characters before < > is different per row.

Thanks!

 

[KLin]

Lookup CHARINDEX() and SUBSTRING().

 

[KAMAZON]

Thanks, that did it.