Substring command in access 2003

[JannetteW]

I want to write a query in access 2003 that will only return records from a field called "Comments', where the first 4 letters has the word Left. Can you help please ?

[PEB]

hi

type:

as field:
instr(1,[Comments],"your word")

as criteria:

=1


:)