Substring

  • Thread starter Thread starter cob
  • Start date Start date
C

cob

Could someone please help on the following Access Query:

SELECT Birth_date
FROM Table
Where substring(Birth_date,1,4)="1970";

Birth_date is a field formatted as Text YYYYMMDD.

Thanks
Cob
 
You must log in or register to reply here.

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

Two Tables Insert Into with Select @@ Identity 2
HELP with query expression........ 1
Query data calculation/conversion? 5
Reference A Query Column 3
Having Count(*) 4
Computed Field 1
Wrap SQL for VBA 6
Access Problem (english) 1

Back
Top