Can you search SQL this way?
doug at artsman.com
Fri Oct 22 16:24:50 UTC 2021
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.
Arts Management Systems Ltd.
mailto:doug at 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?
More information about the omnisdev-en