Combining 2 fields

[Dracozan]

Hello,

I'm studying the basics of SQL.
Currently I'm using Northwind to experiment with SQL statements..
I ran into a problem..

Imagine:
Tablename: 'Employees'
Columnnames: 'FirstName, LastName'.

I want to show all the columns (Firstname, LastName) and add a third column called 'Code' (which consists of the first 3 chars of Firstname, and First 3 cahrs of Lastname)

Already tried some things with CONCAT (Access doesn't recognize the statement!?) and LEFT (Already know that I can combine 2 fields with "&")..

I'd really appreciate any help!

[ADezii]

Hello,

I'm studying the basics of SQL.
Currently I'm using Northwind to experiment with SQL statements..
I ran into a problem..

Imagine:
Tablename: 'Employees'
Columnnames: 'FirstName, LastName'.

I want to show all the columns (Firstname, LastName) and add a third column called 'Code' (which consists of the first 3 chars of Firstname, and First 3 cahrs of Lastname)

Already tried some things with CONCAT (Access doesn't recognize the statement!?) and LEFT (Already know that I can combine 2 fields with "&")..

I'd really appreciate any help!

SELECT FirstName, LastName, Left$([FirstName],3) & Left$([LastName],3) AS Code
FROM tblEmployee;

[Dracozan]

Thanks for your help, problem solved!

[ADezii]

Thanks for your help, problem solved!

You are quite welcome.