Access/SQL function like Oracle's substr ?

[jpercival]

Can anyone tell me if there is an Access SQL function similar to Oracle's substr?
If I wanted to pull the first three characters of a name field from an Oracle table I would code:

Select substr(name,1,3) from mytable;

What would the Access equivalent to this be?

Thanks in advance for any help!

 

[THoey]

Look at the Left, Right and Mid functions in help... Terry M. Hoey

 

[jpercival]

Thanks so much...they are just what I've been looking for!