KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Sorting on a text field
PRODUCT: 4D | VERSION: | PLATFORM:
Published On: July 23, 1999

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.