About CONCAT

Question

you have the choice to use concat or +.
ex :
select concat(fistname,' ',lastname) as fullname from customers
---
select fistname + ' ' + lastname as fullname from customers

the result of will be exactly the same : firstname will be concatinated to a space and to the lastname :

John CARTER
Dalila TALEB
...

Answer 1

thanks for the info 👍 😃

Answer 2

you are well come 😊😊