$O-10.1-SQL : pos('x', strint) in a Where clause ?

jmv jmvoegeli at bluewin.ch
Tue May 18 13:15:47 UTC 2021

Thank you Doug

> Le 18 mai 2021 à 15:02, Doug Easterbrook <doug at artsman.com> a écrit :
> if you are using postgres,   I’d use
> select * from table where col_name not ilike ‘%@%’

I'm using Omnis SQL.

There is a LIKE instruction but I do not know how to use the "NOT"

I've think as something like :

Calculate vText as con("( NOT","(Affi_Cours_Suivis",kSp,"LIKE",kSp,"%",kSq,"/G",kSq,"%","))")


Calculate vText as con("( NOT","(Affi_Cours_Suivis",kSp,"LIKE",kSp,"%","/G","%","))")

part to construct a search string :

where not(Affi_Cours_Suivis like '%/G%)   ## (Affi_Cours_Suivis = column name)

More information about the omnisdev-en mailing list