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

Subquery with Select Substring 1
Need help finding a substring in a array of strings. 1
SQL query with join on substring 5
Case When statement in Access Frontend with Sql Backend 6
MS Query 4
Dynamic Naming of Form Button 3
Viso Wizard no launching? 0
Drop down list control value in vba 2

Top