[FAQ000185]How do I write SQL for fuzzy search when using SQL actions?

Q

How do I write SQL for fuzzy search when using SQL actions?

For example, if you want to search for data that contains the word "Commercial" in the "Company name" field, write

WHERE Company name LIKE %para1%

and specify "Commercial" for para1, the search will not be ambiguous, and only data with an exact match will be searched.

A

Fuzzy search can be performed by setting the SQL parameter value in the form of "%".

(The content of the SQL is fine as "WHERE company name LIKE %para1%")

For example, if "Commercial" is set in A1 cell, the contents of "SQL Parameter Settings" will be as follows.

SQL： WHERE Company name LIKE %para1%

Parameter： para1

Value： ="%"& A1 &"%"

Related keywords

Ambiguous search, wild card