|
-
Nov 7th, 2003, 01:25 PM
#1
Thread Starter
Frenzied Member
SQL Question
Ok I have a database that has a field that is a string, but represents a number on a map. My problem is that for some reason that is a mystery, someone thought it would be a good idea to add a letter to a few of the numbers where a new map was added. So the when I go to pull the data, I have it sorted by those numbers so they are in order. But the few that have letters in them get pushed to the bottom. For example
050
053
065
090
202
50A
50C
53E
So my question is, is there a way I can fix this and get select to return the order "correctly":
050
50A
50C
053
53E
065
090
202
Here is the code I have now:
SELECT * FROM HTEMODJ.UTM105AP ORDER BY UTCNL
MSVS 6, .NET & .NET 2003 Pro
I HATE MSDN with .NET & .NET 2003!!!
Check out my sites:
http://www.filthyhands.com
http://www.techno-coding.com

Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|