Substring

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
 
Top