Hi. I've been asked to create a list of all the contact people where the first 4 characters of their last name are equal to the first 4 characters of their email address. Second find all the contact people whose first name and the last name begin with the same character, create a new column called full name combining their first name and their last name. Finally, add a column with the length of the full name. I'm really struggling with this. and have only done the below.
CONCAT(Firstname,' ', Lastname) AS FullName
FROM [Person].[Person] PP
INNER JOIN [Person].[EmailAddress] PEA
WHERE [EmailAddress] LIKE'First4Characters%'