Databases Reporting with SQL Working with Text Concatenating Text

concat function sql

I am not understanding the concat function in sql

Steven Parker
Steven Parker
159,298 Points

This appears to be a duplicate of your previous question.

You might want to delete this one. Click the small rectangle with 3 dots in it to reveal the option.

Concat can be used to join together strings or columns in a table, this is represented by \ in SQL Playground. You can use a statement like:

select first_name|| ' '|| last_name|| ' ' || '<' || email || '>' as to_field from patrons;