String limitations
The maximum length of an SQL statement string is 65,000 characters.
When the Microsoft Access driver is used, only SQL-92 string constants (with single quotation marks, not double quotation marks) are supported.
The pipe character (|) can't be used in a string, whether the character is enclosed in back quotes or not.
For maximum interoperability, applications should pass strings in parameters, rather than passing quoted strings.
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for