$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,"%","))")

or

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