MSSQL - Check if varchar contains specified characteer

 

Declare @Test varchar(100) = 'aaa@aaa';

IF @Test Like '%@%'

BEGIN

  print ' contains @'

END

ELSE

BEGIN

print ' doesn''t contain @'

END