how should formattingwork in concatination
Steven Parker159,298 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;