Hi there,
In the SQL, we can use LIKE as the filter, but in the Appian, there is no such "operator". so in my case, I am trying to build a query to search a database by people's name.
if using operator "includes" or "starts with" to search value "Michael", then it will return list of people, but if search value "Michael S", it will return nothing, but it should return some.
in the SQL, we can use LIKE 'Michael S%', but dont know how to implement this in the Appian.
Could anyone here can help to point a direction?
Best regards,
Lin
Discussion posts and replies are publicly visible