Remove Characters

[Tony Ramirez]

I have a field that reads CS-080000-A and I want it to read CS-080000 so I
always only want the first nine characters of the field. How would I write
this in an access query.

Thanks!!!

Tony

 

[fredg]

I have a field that reads CS-080000-A and I want it to read CS-080000 so I
always only want the first nine characters of the field. How would I write
this in an access query.

Thanks!!!

Tony

NewColumn:Left(FieldName],9)