--check for first name used as the first part of the last name
SELECT * 
FROM @tbl
WHERE LastName LIKE RTRIM(Fisrtname)+' %'

-- check for a space in LastName (might produce false results, e.g. for Pietro de la Rosa )
SELECT * 
FROM @tbl
WHERE CHARINDEX(' ',LastName)>0