I´m trying to concatenate 2 columns of addresses and cities. Between them I need a dot, just like this:
Calle Antonio, 100. Barcelona
I´m using
SELECT Nombre || " " || Apellido AS "Nombre y Apellido", Correo, IFNULL(Dirección,"")|| "." || Ciudad AS "Direccion"
FROM "BBDD.CLIENTES"
and the outcome is .Barcelona. The problem is I´m trying to aviod the dot when the 1st cell is NULL to get just the city name.
Thanks