Question

Which of the following are text functions? (A) MID()
(B) INSTR()
(C) SUBSTR()
(D) LENGTH()

• A. (A), (B) and (D) only
• B. (A), (B) and (C) only
• C. (A), (B), (C) and (D)
• D. (B), (C) and (D) only

Hint:

String functions include \texttt{LENGTH()}, \texttt{UPPER()}, \texttt{LOWER()}, \texttt{SUBSTR()}, \texttt{INSTR()}, etc. Useful for text manipulation.

Answer 1

The Correct Option is C

Step 1: Review text function definitions.
- MID(): Extracts a substring from text (equivalent to SUBSTR).
- INSTR(): Locates the starting position of a substring within a larger string.
- SUBSTR(): Retrieves a portion of a string.
- LENGTH(): Determines the character count of a string.

Step 2: Determination.
The functions MID, INSTR, SUBSTR, and LENGTH are all classified as text or string manipulation functions.
Final Answer: \[\boxed{(A), (B), (C) \text{ and } (D)}\]