Databases Reporting with SQL Working with Text Concatenating Text

Concatination

how should formattingwork in concatination

1 Answer

Steven Parker
Steven Parker
159,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;