Problem with SELECT SUBSTRING

[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.

 

[Van T. Dinh]

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

HTH
Van T. Dinh
MVP (Access)