I want to do a partial part number search in my BAQ, with the part number passed in as a parameter. Under table criteria, if I add PartNum LIKE @PartNum paramter, I get no results. The sql that is generated is missing the %% in the LIKE, eg. PartNum LIKE ‘RSA’ instead of PartNum LIKE ‘%RSA%’. How do I use the parameter and get the %% into the query?
Pass that % in your param (that’s the easiest way)
Otherwise instead of saying LIke Param… say Like Expression and build your own using the param and a concat.
Thanks Jose, didn’t know I could use a parameter in an expression. Works great.