Posted on 2012-04-04
I have many project numbers in my field that I would like to sort in my bindingsource.
The project numbers are like this:
If I sort this using : ProjetsBindingSource.Sort = "prjNumber DESC"
it will re-order it according to the letters and the numbers, but I would rather it sort it based only on the numbers and not consider the first 2 letters, so I can know exactly what the last number used was.
Is there a way using substring for me to exclude the first 2 characters in the strings when sorting?