Hi gurus,
i want to extract only say the emails that have '@aol.com' in the below string. so if I give you the below string how can I pick only the emails with the domain '@aol.com'
for example, from the below I want only chanc@aol.com; boka@aol.com;
obama@teleson-net.de; chanc@aol.com; rimond@hotmail.fr; boka@aol.com; mariana@yahoo.com;
declare @t table (id int, emails nvarchar(max)) insert into @t values (1, 'obama@teleson-net.de; chanc@aol.com; rimond@hotmail.fr; boka@aol.com; mariana@yahoo.com;')
thanks in advance