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

[Doug Easterbrook]

if you are using postgres,   I’d use

select * from table where col_name not ilike ‘%@%’






Doug Easterbrook
Arts Management Systems Ltd.
mailto:doug at artsman.com
http://www.artsman.com
Phone (403) 650-1978

> On May 18, 2021, at 5:45 AM, jmv <jmvoegeli at bluewin.ch> wrote:
> 
> 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,
> 
> Jean-Marc
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com