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

jmv jmvoegeli at bluewin.ch
Sat May 22 09:28:51 UTC 2021


Hello Doug,

Following your idea, the SQL browser accepted the following statement :

          SELECT * FROM Affilies WHERE Affi_Cours_Suivis LIKE '%/G%'

and

          SELECT * FROM Affilies WHERE Affi_Cours_Suivis NOT LIKE '%/G%'

Both results were perfect.

Problem solved thanks to you.

Thank you very much.

Best regards,

Jean-Marc


More information about the omnisdev-en mailing list