Can you search SQL this way?

Doug Easterbrook doug at
Fri Oct 22 16:24:50 UTC 2021

hi martin.

you don’t say howyour data returned is not as expected….   but

LIKE.   is case sensitive
ILIKE.   is case insensitive

a search of 

name like ‘%Martin%’    will not find MARTIN, only Martin
name ilike ‘%Martin%’    will find MARTIN MArtiN, martIN, martin, etc

always best to try your sql in pgadmin .,. then you can play with parameters and then put it into omnis.

Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at
Phone (403) 650-1978

> On October 22, 2021, at 8:36 AM, Martin Obongita via omnisdev-en <omnisdev-en at> wrote:
> Hi @all,
> I have a similar problem.I am trying to search a postgres database with the statement below in a table class:
> Sta:Where active_status = @[pSearchActiveStatus] AND name LIKE '%[pSearchName]%'
> pSearchActiveStatus and pSearchName are parameters of type int and char respectively.
> This statement does not return the desired results.Is the where clause statement written correctly?
> Rgds,Martin.

More information about the omnisdev-en mailing list