Navigation:  Advantage SQL > SQL Functionality >

Memo Field Limitations

Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

Memo fields cannot be used in SELECT statements that use DISTINCT, UNION, or GROUP BY clauses. Note that memos can be used with the UNION ALL statement because no "distinct" processing is performed.

Memo fields cannot be used in ORDER BY clauses.