Problem Sorting Geodatabase Table on Fields Longer than 255 caracters.

[FrankLahm_III]

Hello,
Has anyone notice a problem sorting a geodatabase table that is longer than 255 characters?
We have a rather long field, much larger than 255 characters, which we occasionally use to sort a file geodatabase table. 

When I try in sort this field in both catalog and ArcMap, I get an error screen stating:
"An invalid SQL statement was used. [SELECT REMARKS, OBJECT FROM HI ORDER BY SUBSTRING(REMARKS, 1, 255) ASC]" 

I attached a screen shot of the error.

I have added other fields at lengths greater than 255 and I receive the same error on any field longer than 255.  We did not see this error until moving our process to Arc10.

Thank You,
-frank

[KevinMayall]

It is still not fixed in Desktop 10.1.  I have a field with length 297 and it gives this error when sorting by the column heading in ArcMap.  The other (shorter) fields sort fine.

[LanceShipman]

I just tested this with 10.1 and it's working for me. I added a 300 width field and calculated values into it and it sorts without an error. Can you post a copy of your data?