Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 400
  • Last Modified:

Bindingsource Sort

Hi,

I have many project numbers in my field that I would like to sort in my bindingsource.
The project numbers are like this:
EV-10000-1
EV-10001-1
EV-10002-3
GT-10003-1
GT-10004-1

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?

Thank you
0
FCapo
Asked:
FCapo
1 Solution
 
CodeCruiserCommented:
You would need to add another, may be hidden, column which only has the digits part. Then sort on that column.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now