Jürgen, great - it works as expected!! Thank you! How can I find out about the engine that is used and the SQL syntax for virtual layers? I'd like to learn about it to be able to build more queries like this one.
Thanks again and best regards, Uwe Jürgen wrote: Not sure which engine virtual layers actually use, but I'd try || instead of + As in sqlite> select '%' || 'foo' || '%'; %foo% instead of sqlite> select '%' + 'foo' + '%'; 0 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 https://www.norbit.de QGIS release manager (PSC) Germany IRC: jef on Libera|OFTC _______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
