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???