My problem is that I have a text field in my database which stores both text and integer values. My problem is that I want to sort the integer values from this field in my asp code as it's supposed to be listed in a dropdown. Because it's stored as text it lists the value 1000 before the value 2 etc.
Is there any way to convert to integer in SQL, somehow order text fields as integers or do I have to manage it in the asp code? Splitting the field in two is not really an option at this point.
Thanks in advance