Extract date from string and insert into field Microsoft SQL Server 2012
<p>Say I have a field UserAddedInfo with a string "User was added to the system and removed from list on 16/05/2016 by User Annon" and a field DateAdded in the same table.</p>

<p>Is there any way in SQL to extract that 16/05/2016 date from the string field and insert it into the DateAdded field as a datetime?</p>

<p>The date in the string is always going to be dd/MM/yyyy.</p>

<p>Thanks!</p>