Problem with SELECT SUBSTRING

O

Olaf Schröder

Hi everybody!

I'm searching for the syntax to select a substring from
a fieldname in a SELECT-statement as:

SELECT SUBSTRING(Field1, 3, 5) AS teststr FROM testdb

with a MS Access Database.

Thank you!
Olaf.
 
V

Van T. Dinh

SELECT Mid(Field1, 3, 5) AS teststr FROM testdb

HTH
Van T. Dinh
MVP (Access)
 
Top