Database

SELECT CASE WHEN SUBSTRING(dmv2_data_text, 40, 1) = CHAR(13)
THEN SUBSTRING(dmv2_data_text, 42, DATALENGTH(DMV2_DATA_TEXT)) 
ELSE SUBSTRING(dmv2_data_text, 40, DATALENGTH(DMV2_DATA_TEXT)) 
END
FROM dmv2 WHERE DMV2_RCD_TYPE = 'R'

This<br />
is a test

This is also<br />
a test

SELECT '--' + CASE WHEN SUBSTRING(TestCol, 5, 1) = CHAR(13)
THEN SUBSTRING(TestCol, 7, 256) 
ELSE SUBSTRING(TestCol, 5, 256) 
END
FROM MyTestTable

--is a test<br />
-- is also<br />
a test<br />

Tom Wright wrote:

Could there be something else there and the system sees and is not reading it right?

select ASCII(SUBSTRING(dmv2_data_text, 40, 1)) AS AsciiCode<br />
from dmv2 WHERE DMV2_RCD_TYPE = 'R'

13 = carriage return<br />
10 = line feed

static DataTable GetSchemaTable(string connectionString)
{
    using (OleDbConnection connection = new 
               OleDbConnection(connectionString))
    {
        connection.Open();
        DataTable schemaTable = connection.GetOleDbSchemaTable(
            OleDbSchemaGuid.Tables,
            new object[] { null, null, null, "TABLE" });
        return schemaTable;
    }
}

Ed.Poore wrote:

Can you rephrase that in English please

Ed.Poore wrote:

I should start charging you for these sigs

Ed.Poore wrote:

A few

Ed.Poore wrote:

typical western shot where the body went tumbling backwards

SqlConnection conn = new SqlConnection("Server=bla;Initial catalog=bla;User Id=bla;Password=bla");<br />
OleDbConnection conn2 = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\bla.mdb");