Hi Din,

​For this can you please try the comma symbol. If you have commas within your content please try a more unique symbol of ^.

​Please let me know if this works for you.

​Kind Regards

​Demi

Hi Demi,

I have table of Products with the columns Product No, Product Name, and Product Description.

Example, the user want to search hard disk, so they will key in something like "hdd hard disk". The search query will be dynamic, meaning the user can key in only "hdd" or maybe mixture of different keyword like "hdd hard disk 4tb seagate"

What I trying to achieve is splitting the search query into multiple words, then check the Product No, Product Name, and Product Description if it contain each individual word.

Thanks,
Din

Hi Din,

​Could you please confirm what it is you're trying to filter and how you intend the user to supply search terms?

Kind Regards
​Demi