Hi, maybe it's again some strange local issue, but I can't find a way to make CASE WHEN working in a DB Manger query or in a Vitual Layer.
The example is analog to https://www.sqlitetutorial.net/sqlite-case/ I would like to populate a new column "category" in that select SELECT * CASE WHEN status = 'v' THEN 'v' ELSE 'nv' END category FROM table; Whatever I try, the result is always a: near "CASE": syntax error This should have been the preparation for a much more complex query, but I even fail at the start :( Any ideas whats wrong? Cheers, Bernd
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
