Databases Reporting with SQL Working with Text Concatenating Text

select CONCAT(first_name , " " ,last_name , " " ,email)AS "to_field" from patrons what is wrong in it

plz suggest correction.

1 Answer

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 48,713 Points

With SQLite you concatenate with double pipes ||. You will also need to enclose the email in angel brackets <>.