sorting
-
I wanted the sotring of string column(sql server 2000 database table). the table contains the following entries aa 02 18 1 11 22 1a 2 after sorting these entries by the same column. it gives the following result 02 1 11 18 1a 2 22 aa but the above sorted order is not required. then look at the ascii chart http://www.asciitable.com/[^] Now according to my understanding , i thought i should sort the list in the order in which the ascii codes are listed. Am I doing in the right direction ?
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
-
I wanted the sotring of string column(sql server 2000 database table). the table contains the following entries aa 02 18 1 11 22 1a 2 after sorting these entries by the same column. it gives the following result 02 1 11 18 1a 2 22 aa but the above sorted order is not required. then look at the ascii chart http://www.asciitable.com/[^] Now according to my understanding , i thought i should sort the list in the order in which the ascii codes are listed. Am I doing in the right direction ?
If you have an apple & I have an apple and we exchange our apples, then each of us will still have only one apple but if you have an idea & I have an idea and we exchange our ideas, then each of us will have two ideas!
Hi, yes, if we use ready made sorting function in .NET library then it will sort based on ASCII characters, but here i think your sorting includes numbers and characters and zero based numbers also, so i think you should make your own sorting function which will use Comparer class to compare values and then will sort based on your requirement. Bye :-D .
Chirag Patel Programmer Analyst India