使用tsql从字符串中提取电子邮件地址

I'm trying to extract email addresses from an existing comments field and put it into its own column. The string may be something like this "this is an example comment with an email address of [email protected]" or just literally the email itself "[email protected]".I'm trying to extract email addresses from an e