Check this,

declare @str varchar(100)

set @str='mail1@hotmail.com; mail2@hotmail.com'

select LEN(@str) - LEN(REPLACE(@str, '@', ''))