Hi Lynn

Thank for...

Hi Mark

Each person in the contact table (and therefore each entry in that table) is unique, so it might be something like this:

1 UNITED KINGDOM
2...

Hi Mark

Thanks for your help.

Yes, running that query only produces one line (as it should do). The mystery deepens!

Best wishes
Jon

Hi Andrew

Thanks for your help.

Running the following SQL shows just 1 record.

SELECT COUNT(serialnumber)
FROM Contact
WHERE Serialnumber='100045'

The column is a Primary Key...

Thank you both. I've got this to work now.
Best wishes
Jon

Thanks Mike.

I'm trying to concatenate them together so that I can compare them to a spreadsheet that is concatenated in the same way. I can then using the...

Thank you, yes, I want to make the columns FIRSTNAME, KEYNAME and DATEOFBIRTH into another column called FULLNAME. I want to do this only in the SELECT statement and not...

Hi Drew
No, unfortunately it produces three columns called SERIALNUMBER, DOB AND FULLNAME.

So, it doesn't include DOB or DATEOFBIRTH in the FULLNAME concatenation.

Many thanks
Jon

Hi Drew
Perfect thanks!

The only issue that I have now is trying to also add DOB into the CROSS APPLY( VALUES(FIRSTNAME + ' ' + KEYNAME ) )...