I have some SQL in MS SQL 2005 that is trimming the result to 10 characters. Here is the SQL:
ISNULL(CUSTOMERS_1.CUSTNO, LTRIM(RTRIM(dbo.CUSTOMERS.FNAME)) + ' ' + LTRIM(RTRIM(dbo.CUSTOMERS.LNAME)))
This is supposed to look at a given field and if the value is null then essentially concatenate some data together. The original CUSTOMERS.FNAME = CHRISTOPHER, and the original CUSTOMERS.LNAME = SMITH, but what gets returned is CHRISTOPHE (exactly 10 characters). I've tried to add CAST or CONVERT, but that didn't seem to help.
Can anyone help me determine why it's shortening the results?