PSIcapture Database Lookup: Run LIKE query if a wildcard character (% or *) was entered

Question:

What does this option do within PSICapture Advanced Indexing database lookup?

Run LIKE query if a wildcard character (% or *) was entered

Scenario: (Actual customer question)

Is it possible to do a filter on the information that is being accessed through the Advanced Indexing step that is being done by an ODBC driver?

Sometimes the field I’m looking at may contain letters that I’m trying to ignore. For example, my match code is 123 but in the customers database it may be A123 or TREVOR 123 MARCH.

Answer:

Two options are intertwined with this option.

[Implied Wildcards] and [Run LIKE query if a wildcard character (% or *) was entered]

Implied Wildcards enabled will force a LIKE query to always run.

Run LIKE query if a wildcard character (% or *) was entered will run a LIKE query only if the additional characters % and * are entered.

If you would like to remove LIKE queries all together from your database lookup ensure both options are disabled.