How to retreive substring of field in Access 2002?

[heckstein]

I am working in Access 2002 and have a query that outputs a course code which is either all alpha or alpha numeric (such as ODLAT or ODLAT1). I want my output to report just the first three alpha characters of the course code (ODE). I tried using SUBSTRING like this: SUBSTRING ( I.LEARNINGACTIV ITYCODE, 1, 3), but received an undefined function error. Can someone provide me with the correct way of doing this. I am a novice. Thank you!

[heckstein]

Never mind. I found the LEFT function which appears to be working. Not sure how to delete my original post. Thanks.

[PEB]

MID(Your string, Start pos, end pos)
MID(Your string, 1, 3)

also works!

:)