excel query with wild card in parameter

[kpbbbb]

Hi Good morning everyone.

Having a tough time passing a parameter value from a cell into the query. The field I am filtering is a string but I can only query based on the first 12 characters.

So I have been trying to use "begins with" or with "like" and wild card characters, without any luck.

Does anyone have experience with the syntax either in the command line or the criteria field in the MS query to get this done.

Thanks for your help!

 

[kpbbbb]

GOT IT! looking through some of the posts here, I was able to pass the text string with a "%" appended to the end, it works.