SELECT CONCAT(

orgName, CHAR(13,10),

orgAddr, CHAR(13,10),

orgCity, ', ',

orgState, ' ',

orgZip)

FROM organization

WHERE orgID = 1

/* Create and load a table that contains a list

of organizations in Seattle that assist

people in finding jobs

*/

-- Select the database we want to modify

USE dataExamples;

-- New table so if another one with this name exists - delete it

-- The name is for Star Fleet members

DROP TABLE IF EXISTS `organization`;

CREATE TABLE `organization` (

-- Let us have the database provide a unique key

`orgID` INT(5) AUTO_INCREMENT,

-- Organization or Business Name

`orgName` VARCHAR(30) NOT NULL,

-- The Primary Address Line

`orgAddr` VARCHAR(30) NOT NULL,

-- The City of the entity

`orgCity` VARCHAR(20) NOT NULL,

-- The Geographical State of the Entity

`orgState` CHAR(2) NOT NULL,

-- The postal code for the entity

`orgZip` VARCHAR(20) NOT NULL,

PRIMARY KEY(`orgID`)

);

-- Populate initial data into table

INSERT INTO `organization` VALUES

(NULL, 'CareerPaths', '19109 36th ave W.','Lynnwood #201','WA','98036'),

(NULL, 'Kim Finch Cook & Company', '9805 NE 116th St #7404','Kirkland','WA','98034'),

(NULL, 'Matrix Finance & Accounting', '600 Stewart Ave. #1220','Seattle','WA','98101'),

(NULL, 'New ERA Staffing', '903 East Main St. #103','Auburn','WA','98002'),

(NULL, 'Resourceful HR', '6523 California Ave. #441','Seattle','WA','98136');

How Do I Send A Non-standard Character To The Output ?