wildcard search scripting and UI

[sammarcow]

I need the equivalent of the following mssql search in a GlideRecord, or a way to do this in the UI

select *

from user

where title like '*chief*officer*'

In the above example records from table user having title "Chief Technology Officer" would be returned but records with title "Officer and Chief Advisor" would not.

If there is a way to provide a regex to a query that would also work.    

Message was edited by: William Sammarco grammar corrected

Message was edited by: William Sammarco added alternate solution path

[sammarcow]

Hi, this would return "Officer and Chief Advisor," as an example I've previously provided -   so will return erroneous results.      

[Kalaiarasan Pus]

But in the question, you seem to suggest that you would want that result to be returned ?

[sammarcow]

Please review the original post.