Substring

[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

 

[Henk van Boeijen]

WHERE LEFT(Birth_date,4) = '1970'