Databases Reporting with SQL Working with Text Concatenating Text


how should formattingwork in concatination

1 Answer

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