SELECT LEFT(x.Comment,20) + IIF(LEN(x.Comment>20,'...','')
  FROM myTable x

Sorry, I meant to put the 7th character not the 6th:

            
April 15, 2020 at 3:37 pm
            
#3743174

            
            
                                                
        

Could be some string terminating characters in the account number, see if this returns anything from your source table

select ASCII(SUBSTRING(AccountNo,6,1)), AccountNo
from mySourceTable
where ASCII(SUBSTRING(AccountNo,6,1)) is not null

CREATE TABLE #temp(SSN varchar(20),TableName sysname);

INSERT INTO #temp(SSN,TableName)
SELECT @SSN, 'dbo.MyTable1' 
 WHERE EXISTS(SELECT *
 ...

CREATE PROCEDURE FindSSN(@SSN varchar(20)) AS
BEGIN

    CREATE TABLE #temp(TableName sysname);

    INSERT INTO #temp(TableName)
    SELECT 'dbo.MyTable1' 
   ...

I've not yet moved from SQL 2012 to 2019 but in previous database upgrades the SSIS packages have to be rewritten or at least recompiled in Visual Studio.

I'm interested to...

" it returns a null value which ado.net doesnt like"

Really!, there is a database driver that doesn't handle nulls?!

You should check the which index, on the table that has this column, is being used (from the execution plan), then add the column you have added to the INCLUDE...

The first thing you should do it look at differences in the execution plans.

Did you just add the column to the rows that are being selected and not add it...

Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys:...

Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys: -1 for...

Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys: -1 for unknown, -2...

Ralph Kimball has a method of not having any nulls in dimension tables. Instead, on the dimension table there are rows with negative keys: -1 for unknown, -2 for not...

Yes, that's what you need to ask for.

Tava,

Can you supply some more details of the processing involved?