SELECT E_Mail, 
  CASE WHEN E_Mail LIKE '%_@_%_.__%' 
    THEN 'Valid' 
    ELSE 'No valid' 
  END [Validate]
FROM 資料表