Show First 10 Characters

A

Alec Green

I would like to show the first 5 characters of my customer field in my
query, can anyone help

ie Customer: Joe Bloggs

returns Joe Bl

Thanks
 
Top