How to Extract only email id in SQL SERVER -


how extract email id below example (i.e. abc@abc.com, mno@mno.com, etc.)? each row can contains multiple email ids...

"abc" <abc@abc.com>; "xyz" <xyz@xyz.com>; pqr@pqr.com; "mno" <mno@mno.com> 

in mysql use substring_index in following:

select substring_index(substring_index(id, '>', 1), '<', -1) email tbl; 

in sql server be:

select substring(id, charindex('<', id) + 1 , charindex('>', id) - charindex('<', id) - 1) tbl; 

Comments