Comparing fields

[OtarBoy]

How do i return the records with the first 2 digit of the serial number beginning with 02? Can anyone provide with the code?

SELECT *
FROM TABLE
WHERE ......................

I tried the LIKE method but it can't seem to work with the ACCESS. So are there other ways?

[andi_g69]

1)Select * from Table where field LIKE "02*"

2)Select * from Table where Left (field, 2) = "02"