KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Sorting on a text field
PRODUCT: 4D | VERSION: | PLATFORM:
Published On: July 23, 1999
Your current browser may not allow you to download the asset. We recommend Mozilla Firefox or Google Chrome.
Log In

You cannot directly sort on text fields via code using a syntax such as:

ORDER BY([Table1];[Table1]TextField;>)

However, what you can do to sort a text field via code is:

ORDER BY FORMULA([Table1];[Table1]TextField+"";>)

A limitation is that the sort only uses the first 80 characters of the text.