Query to display first 3 characters

[KenshiroUK]

Hi all I have an inventory table with a column of SKUs, I wish to create a simple select query that takes the first 3 characters of the sku and displays it.

any idea how?

 

[pr2-eugin]

Have you considered using Left()

 

[KenshiroUK]

Have you considered using Left()

how does that work, or more importantly what would the code be?

 

[pr2-eugin]

Left, is a function in VBA that takes in a String value and produces an Outpu based on the length given..
Example:

? Left("Paul", 3)
 Pau
? Left("32A Bank Street", 3)
32A

The code will be something along the lines of..

SELECT Left([SKU_FieldName], 3) AS FirstThree FROM theTableName;