SQL Server : search for Email in String -

SQL Server : search for Email in String -

this question has reply here:

tsql email validation (without regex) 6 answers

i working in sql server environment , have varchar(100) column called additionaldata. sometimes, not always, column contain email. need help building query returns rows in additionaldata has email address in it.

assuming emails contains @:

select * mytable additionaldata '%@%';

sql sql-server sql-server-2008