Combine 2 fields into 1 via SQL query

  • Thread starter Thread starter amelia
  • Start date Start date
A

amelia

I need an SQL statement to combine two fields into one -
displaying that results in an SQL query. This is how my
data looks:

My Data:
Record 1 FirstName = John LastName = Smith
Record 2 FirstName = Mary LastName = Smith
Record 3 FirstName = Tom LastName = Smith
Record 4 FirstName = Sally LastName = Smith

My SQL Statement:
SELECT [FirstName], [LastName]
FROM People
WHERE (([LastName]) Like [Enter Last Name])
ORDER BY [LastName];

Desired Output:
FullName = John Smith
FullName = Mary Smith
FullName = Tom Smith
FullName = Sally Smith

I know how to concatenate in a form or report (=
[FirstName]&" "&[LastName]). This doesn't really work for
me - I need the results in plain table view.

Any ideas?

Thanks?
/amelia
 
SELECT Trim([FirstName] & " " & [LastName]) AS FullName
FROM People
WHERE [LastName] = [Enter Last Name]
ORDER BY [LastName];
 
Back
Top