how do I extract a substring from a string field in Access

[FiveStarFlight]

I want to include a simple built-in function (mid) into a SQL view.

 

[Douglas J Steele]

In the list of fields, rather than SELECT Field1, Field2, ..., you'd SELECT
Field1, Mid(Field2, 4, 6) AS Field2_Substring, ...