Can you search SQL this way?

[Doug Easterbrook]

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 artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On October 22, 2021, at 8:36 AM, Martin Obongita via omnisdev-en <omnisdev-en at lists.omnis-dev.com> 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.