CREATE TABLE [dbo].[MyTest]
[Test1] [varchar](20) NULL
) ON [PRIMARY]and inserted some data with a carriage return in itINSERT INTO MyTest(Test1)
my data')When looked at through the grid view of SQL Server Management Studio it appears as
This is my data and this is where the confusion was coming in - those control characters had been replaced with spaces - so how could we tell what they were.When we looked at the data through through the text view of SQL Server Management Studio it appears as
my dataAnd to double check I did a search using SQL as
WHERE Test1 LIKE '%' + CHAR(13) + '%'