I have setup a dynamic field in Laserfiche 10.1.1.320. When I test the field, it is pulling back results with special characters and numbers at the beginning of the list, which is what I would expect. But then it is sorting by all upper-case values, proper case values, and then lower-case values.

Is there a way for it to not be case sensitive? When I query the same data in SQL Management Studio by using ORDER BY, it puts them in alphabetical order regardless of the case.