sql server using SUBSTRING with LIKE operator returns no results
<p>I created this CTE that returns first and last names from 2 different tables. I would like to use the CTE to identify all of the records that have the same last names and the first name of one column starts with the same first letter of another column.
This is an example of the results of the CTE.  I want the SELECT using the CTE to return only the highlighted results:</p>

<p><a href="https://i.stack.imgur.com/rcb4h.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/rcb4h.png" alt="Query Results"></a>   </p>

<pre><code>;WITH CTE AS
            (
            SELECT AD.FirstName AS AD_FirstName, AD.LastName AS AD_LastName, NotInAD.FirstName As NotInAD_FirstName, NotInAD.LastName As NotInAD_LastName 
            FROM PagingToolActiveDirectoryUsers AD JOIN 
                (
                SELECT FirstName, LastName
                FROM #PagingUsersParseName
                EXCEPT
                SELECT D.FirstName, D.LastName
                FROM PagingToolActiveDirectoryUsers D 
                WHERE D.FirstName &lt;&gt; D.LastName AND D.LastName &lt;&gt; D.LoginName
                    AND D.LoginName LIKE '%[0-9]%[0-9]%'        
                ) AS NotInAD ON NotInAD.LastName = AD.LastName
            )
            SELECT *
            FROM CTE
            WHERE (AD_LastName = NotInAD_LastName) AND (AD_FirstName LIKE ('''' + SUBSTRING(NotInAD_FirstName, 1, 1) + '%''')) 
            ORDER BY AD_LastName, AD_FirstName;
</code></pre>

<p>The result of this query returns no rows.
What am I doing wrong?</p>

<p>Thanks.</p>