Query Substrings
From MidrangeWiki
See Query for links to other tips.
In Query, pieces of fields can be extracted into new fields called substrings. An example of this will be given in Query Date Math.
Before you try this, or reassemble pieces of fields using Query Concatenation it would help if you understood Query Field Types.