I am trying to select only a portion of a field from an Access database.
Here is the statement I wish to execute:

SELECT SUBSTR(NFDESC,1,30) FROM EINFP

The error I get is...

"Undefined Function 'SUBSTR' in expression"

Isn't that the way to do a substring in Access/Jet?

What am I doing wrong???

Doug