title: SSRS report template Code
body: <p>I am trying to write the VBA code within the SSRS report templates and I have different conditions that map to a the same outcome. The example is when someone selectes an option "Employee picked" or "Single picked" or "Emp Picked"</p>
  
  <p><code>Public Function ChangeCov(ByVal s As String) As String 
     s= s.Trim()
  If s.ToUpper = "Picked".ToUpper Or s.ToUpper ="Single".ToUpper
      Return "S"
  Else : Return s
  End If
  End function</code></p>
  
  <p>is there a way like in SQL putting a wildcard in?</p>
  
  <p>Thanks for the help.</p>