Hello
Can anyone help me tweak the following prompt?
In my query I have the following prompt: Like [Enter Company Name] & "*". It works fine to pick up anything that begins with the name inputted by user. HOWEVER, I would like a wildcard that can pick up anything that contains the input name added by the user.
Hope this make sense. Any help is appreciated.
Thanks
Can anyone help me tweak the following prompt?
In my query I have the following prompt: Like [Enter Company Name] & "*". It works fine to pick up anything that begins with the name inputted by user. HOWEVER, I would like a wildcard that can pick up anything that contains the input name added by the user.
Hope this make sense. Any help is appreciated.
Thanks