Searching for a string in multiple fields in a table
If you are not using any wild cards then can use =  

Starting a like with % kills the use of an index
Not good 

Just stay with 

SELECT * 
  FROM sometbl 
 WHERE FIELD0 = 'zap' 
    OR FIELD1 = 'zap'


Can use variable to only set once
Can use in

declare @val varchar(200)  = 'message/rfc822'

select sID, mimeType, caseID 
  from docSVsys 
 where mimetype = @val 
    or caseID   = @val;

select sID, mimeType, caseID 
  from docSVsys 
 where @val in (mimetype, caseID)