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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Case When statement in Access Frontend with Sql Backend 6
MS Query 4
Subquery with Select Substring 1
Why does view return different results in Enterprise Manager than in adp? 1
SUBSTR AND MID FUNCTIONS IN SELECT 1
Help with Replace() 11
SUBSTRING function 1
How do I use the 'Substring' function 3

Top