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

jmv jmvoegeli at bluewin.ch
Tue May 18 12:45:34 UTC 2021

Hello listers,

I'm struggling with SQL statement.

I want to find records that do not contain a specific character:

something like :

SELECT * WHERE pos("@",Col_Name) = 0

I do not know how to do this.

Could you help me ?

best regards,


More information about the omnisdev-en mailing list