Databases Reporting with SQL Working with Text Concatenating Text

SELECT Street || ", " || " " || City || ", " || " " || State || " " || Zip || "." || " " || Country || " " AS address

SELECT Street || ", " || " " || City || ", " || " " || State || " " || Zip || "." || " " || Country || " " AS address FROM addresses

1 Answer

KRIS NIKOLAISEN
PRO
KRIS NIKOLAISEN
Pro Student 42,619 Points

You have a lot of extra spaces between fields. Try:

SELECT Street || ", " || City || ", " || State || " " || Zip || ". " || Country AS address FROM addresses