[Qgis-user] SQL statement

[Jürgen E. Fischer]

On Wed, 02. May 2012 at 14:14:12 +0100, Filipe Silva Dias wrote:
>    Dear all,
> 
>    I'm trying to fill a column using an SQL statement, but Ive been
>    unsuccessful so far. In LibreOffice I would use the following syntax:
> 
>    =IF(AND(FIELD1="A";FIELD2<>"B");X;Y)

I suppose something like:

CASE FIELD1='A' AND FIELD2<>'B' THEN X ELSE Y END


Jürgen

-- 
Jürgen E. Fischer         norBIT GmbH               Tel. +49-4931-918175-31
Dipl.-Inf. (FH)           Rheinstraße 13            Fax. +49-4931-918175-50
Software Engineer         D-26506 Norden               http://www.norbit.de
committ(ed|ing) to Quantum GIS                         IRC: jef on FreeNode                         

-- 
norBIT Gesellschaft fuer Unternehmensberatung und Informationssysteme mbH
Rheinstrasse 13, 26506 Norden
GF: Jelto Buurman, HR: Amtsgericht Emden, HRB 5502