Which function is often described as similar to the LEFT function because it can extract characters starting at a defined position?

• A. LEFT
• B. RIGHT
• C. FIND
• D. MID

Answer: (D)

Extracting a portion of a string from a specific point inside the text is the key idea. LEFT takes characters from the start of the string, fixed from the left edge. MID, on the other hand, is described as similar because it also returns a substring, but it lets you choose exactly where to begin inside the string and how many characters to take. That start position flexibility is what makes MID the right fit for extracting characters starting at a defined position. For example, MID('ABCDEFG', 4, 3) gives 'DEF' by starting at position 4 and taking 3 characters. RIGHT would pull from the end, not from a chosen internal start, and FIND only reports where a substring occurs rather than returning a piece of text.