SUBSTRING(string, start, length). In Microsoft Access and MySQL, you can use. MID(string, start, length). In Oracle, use. SUBSTR(string, start, length). A good ...
https://www.google.com/search?q=SubStr+in+MS+Access&rls=com.microsoft:en-us:IE-SearchBox&ie=UTF-8&oe=UTF-8&sourceid=ie7