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 _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
