SQL72 error means?
-
Multi-Line Field not valid in ORDER BY clause
-
Multi-Line Field must be the Left operand of the Comparison
-
Multi-Line Field only valid for LIKE, Contains ([), or NULL Comparison
-
None of these
Reveal answer
Fill a bubble to check yourself
A
Correct answer
Explanation
SQL72 indicates that a multi-line text field cannot be used in an ORDER BY clause because multi-line fields don't have a well-defined sorting order. The database engine cannot determine how to properly sort rows based on multi-line content. Options B and C describe other potential multi-line field restrictions that would apply in different contexts, while option D is incorrect since option A accurately describes the error.