SUBSTRING or SUBSTR in Access

[cckrocks]

Is there any way to extract a substring from an Access 2000 DB? I have used a query such as "SELECT SUBSTRING (content,1,250) from articles" using mySQL to grap the first 250 characters from a column. This query does not seem to work with Access. Any input or a way to do the same thing?

 

[THoey]

Look up the following functions in the Help:
INSTR()
LEFT()
RIGHT()
MID() Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.

 

[cckrocks]

Thanks... it was MID()