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

[jmv]

The method contains :

If (tChoix.cX_Cours_Grottes)
	If (tChoix.cX_Addition_Cours_Grottes)
		Calculate vText as con("(Affi_Cours_Suivis",kSp,"LIKE",kSp,kSq,"%","/G","%",kSq,")")
		Calculate vOp as vOp_Or
	Else If (tChoix.cX_Exclusion_Cours_Grottes)
		Calculate vText as con("( NOT","(Affi_Cours_Suivis",kSp,"LIKE",kSp,kSq,"%","/G","%",kSq,"))")
		Calculate vOp as vOp_And
	End If
End If

and many more like that.

(I've isolated the "/G" to simplify the change. It looks more than a little awkward !)

Is that possible ?



> 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 ‘%@%’
> 
> 
> 
> 
> 
> 
> 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 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com