当前位置:优学网  >  在线题库

在SQLITE中连接2列

发表时间:2022-07-22 00:33:37 阅读:70

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

🎖️ 优质答案
相关问题