Welcome to the Treehouse Community
Looking to learn something new?
how should formattingwork in concatination
Steven Parker216,136 Points
Concatenation is just joining strings together, which can be from fields or literals. There's no "formatting" involved.
For example, if you were concatenating names of doctors, you might do something like this:
SELECT first_name || ' ' || last_name || ', MD.' AS Doctors FROM doctor_table;