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.