lyancsie
Reputation: 678
How to get a specified character of a string
I would like to know, how to get a specified character of a string in MS-Access 2010. The exact thing I would like to do is to get the 2nd character of a string.
Upvotes: 0
Views: 60
Answers (1)
dnoeth
Reputation: 60462
Access doesn't support Standard SQL's SUBSTRING, but there's a similar function, MID:
MID(col, 2,1)
Upvotes: 3
Related Questions
- SQL Server - how can I get a string that starts with specific characters
- find specific part of string while using sql to query a database
- Is there a function in ms-access sql-query with which one can extract a certain string?
- referencing a specific character out of a string in SQL Server
- Access Database query on finding specific character in a sentence
- String Extraction between two characters
- Get the specific characters from a string
- MS Access Substring
- Select part of a string
- How to extract specific value from string in MS Access