LISTING 1: Example of Inserting a Carriage Return into a Column

DROP TABLE BadTextData
GO
CREATE TABLE BadTextData
(
TextId integer identity,
TextValue varchar(1000)
)

INSERT INTO BadTextData (TextValue) VALUES ('This text does not have a carriage return.')

/*
Notice that the Enter key has been pressed after the word have in the following string:
*/
INSERT INTO BadTextData (TextValue) VALUES ('This text DOES have
 a carriage return.')