Is it possible to return results from a CONNECT command using the LIKE operator instead of a straight equality operation? For example, instead of returning all rows where a field=’SMITH’, can you return all rows where a field LIKE ‘%SMITH%’?
Hi Ryans. This is possible and already in the application. After you setup your connection and you start configuring your action, in the send parameters, add a new parameter. The first column is the field that will be used in the ‘LIKE’ phrase. In the middle column, change the ‘=’ to ‘LIKE’ by double clicking that column, then choosing ‘LIKE’. The last column is the corresponding field in the database.