Check this,

declare @STR varchar(100)

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

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