I want to put 'A0' as the first two in this field.

[Sxbbb]

I have a field 'Lot '

in field  'Lot ' contains data :

I want to put 'A0' as the first two in this field.

example :

A0165052171

A0172050012

.

.

.

[maxgro]

LOAD

...

'A0' & Lot as NewField,

...

[Sxbbb]

and  I want to add '-' to count the 8th data from the left.

EX

A0165052-171

A0172050-012

[BrunPierre]

Left('A0'&Lot,8)&'-'&Mid('A0'&Lot,9) as Lot

[Sxbbb]

I use this code value came out correct : Left('A0'&Lot,8)&'-'&Mid('A0'&Lot,9) as Lot

but want to cut the last one or the 11th one out 

EX

A0165052-17

A0172050-01

[BrunPierre]

Here's one option

'A0'&Left(Left(Lot,8),6)&'-'&Mid(Left(Lot,8),7)