Show First 6 Characters

  • Thread starter Thread starter Alec Green
  • Start date Start date
A

Alec Green

Try Again!

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

ie Customer: Joe Bloggs

returns Joe Bl

Thanks
 
Use the LEFT function.

Field: First6: LEFT([CustomerField],6)

In an SQL Statement

SELECT LEFT([CustomerField],6) As First6, ...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Show first 6 characters 3
Show First 10 Characters 1
Query to return only one value. 5
Multiple rows in query 2
time issue 2
hopefully quick question 2
Update primary key field with multiple "where" clauses 0
Changes Since Moving to Exchange 3

Back
Top