I am a fledgling Sharepoint Services Admin. We created an Sharepoint
Services Intranet site for our office and on that we created a web page using
the Project Tracking web part. On that page I created a Public View that
sorts on a column we created called Task Order. Task Order column is defined
as a "Single line of text" with a max of 8 characters and on the public view
is sorted in Ascending order. For some reason that column sorts in the
following order: symbols, numbers, letters with no case sensitivity (example:
sorts Task Orders starting with ~ first, 1 second, i third and T last). I
expected it to sort on ASCII code order 1 (hex 31), T (hex 54), i (hex 69)
and then ~ (hex 7E). Any idea why this is happening and how to fix it?
--
Alan