title: Need a value prompt to select multiple items and use wildcard
body: <p>I have this filter currently setup on my query and it works
  [Replenishment Code] contains ?vendor?</p>
  
  <p>However i need to replace "contains" with "in" to get multi select working in my value prompt</p>
  
  <p>BUT, i am not able to add a wildcard to the "in" operator like so
  [Replenishment Code] in ?vendor? + '%'</p>
  
  <p>Is there any way to do this?</p>
  
  <p>My replenishment code is setup like this
  AIPRODU-WA
  AIPRODU-SF
  etc...</p>
  
  <p>But i had to substring ?vendor? to everything before the "-". so you see
  AIPRODU</p>