Query that find values that have a word in any position

Question

I want to create a query like:

WHERE name LIKE '%ui%'

To find any values that have "ui" in any position of the word, for example:

L'ui's or adoq'ui'n

is this possible to do?

I tried with "Operator::LIKE" but this, only find word that match from the start.

Please, regards.

Answer 1

Hi Luis,

Could you please explain the issue in detail, it will help us to provide better support to you.

Regards,

Priyanka Singh

App42 Team

Comments

how about now?