AnsweredAssumed Answered

quotes and double quotes in an SQL expression

Question asked by soldous on Feb 1, 2016
Latest reply on Feb 1, 2016 by kimo

Hello

I have a layer with a string attribute Layer and I want to select every record that contains string PLOCH anywhere in the whole string and doesn't end on character _ using Python script.

My expression is sqlprikaz='"Layer" LIKE ' + "'%PLOCH%'" and "Layer" <> "%_"

First I had only the first part of the expression and it worked but when I add the second part I have a problem where quotes and double quotes should to be and the expression doesn't work.

Can anyone explain me the rules of quotes and double quotes in expressions with more conditions please?

Outcomes