Randal Hale (He/Him)Is concat_ws missing in QGIS 3.44? I have concat - but that's not doing what I need it to do.#qgis
Paul Ramsey 🗳️@rjhale1971 Concat_ws is a database superpower, particularly the null handling.
@pwramsey Yep - that's what I needed. I had nulls in addresses but had to add like 8 strings together. I think I'm having some sort of mandela effect. I've sworn I've used it in the field calculator in QGIS because I remember going "Hey this is a SQL command". Probably happened when I married my supermodel wife.
Keith Jenkins@rjhale1971 @pwramsey concat_ws is available in QGIS virtual layer queries, although it doesn't appear as an autocomplete suggestion. It looks like SQLite added it in Nov 2023, which I guess is what enabled it in QGIS virtual layer queries.