Write a query against the ADDRESS table to show the names and phones of all persons concatenated in following form

Q. Write a query against the ADDRESS table to show the names (first name, last name) and phones of all persons concatenated in following form:

TinaSeth23456789

Moradk.22211890

Table ADDRESS (contains following eight columns)

 

Last Name	VARCHAR (25)
FirstName	VARCHAR (25)
Street	VARCHAR (50)
City	VARCHAR (25)
State	CHAR (2)
Zip	NUMBER
Phone	VARCHAR(12)
Ext	VARCHAR(5)

Answer =

 

SELECT CONCAT (FirstName, LastName, Phone) FROM ADDRESS;