title: Log Parser Case statement
body: <p>I am using case statements in Log parser to find out the browser names like,
  case strcnt(cs(user-agent), 'MSIE') when 1 THEN 'IE' </p>
  
  <p>But some of the user agent fields have 'MSIE' more than one time, is there any way to check >=1</p>
  
  <p>case strcnt(cs(user-agent), 'MSIE') when >=1 THEN 'IE' </p>
  
  <p>or</p>
  
  <p>case when strcnt(cs(user-agent), 'MSIE') >=1 THEN 'IE'</p>
  
  <p>I tried these statement iis giving syntax error.</p>
  
  <p>Please give some other workaround to check more than one occurance..
  Thanks</p>