Databases Reporting with SQL Working with Text Concatenating Text

1 Answer

53,479 Points

Here you are concatenating first_name and last_name and email with some formatting. The alias for this column will be 'to_field'. For the formatting there is a space between first and last name. Email is surrounded by <>. Use the concatenation operator || to create this field.

Some examples/hints:

To create a space

SELECT C1 || ' ' || C2 FROM table

To format email

SELECT ' <' || email || '>' FROM table

To alias as 'to_field'

SELECT C1 || C2 || C3 AS 'to_field' FROM table