Why concat function in sql

Question

Hi everybody!

Why use concat function from sql if I can to use concat function from programming language: php, c#, python etc?

what is the benefit?

I don't understand

Answer 1

With concat function you could create a single coloum to use later and yes you could use it in programming languages but the point is to use it in sql without using other languages

Answer 2

so what is the profit to use concat in sql instead of programming language?

Answer 3

I understand. For optimal using CONCAT need using AS for create and get result as new column. this column will unite the others. without as - no profit