Gossamer Forum
Home : General : Databases and SQL :

Order by last three numbers of five numbers

 
Order by last three numbers of five numbers
Ok I this this is really simple. I am new to SQL. I am trying to use the order by to have jobs listed on a webpage. It works great but, when the company started out the owners came up with a job number scheme that used year and then a three digit number. Example: 85001 (YYJOB) The jobs sort great until 2000. 00701 appears before 85001. How can I sort the information excluding the first two digits.
Subject Author Views Date
Thread; locked thread; hot thread Order by last three numbers of five numbers briski00 8742 Feb 19, 2003, 3:57 PM
Thread; hot thread Re:Update here is what I have so far
briski00 8453 Feb 20, 2003, 8:27 AM
Thread; hot thread Re: [briski00] Re:Update here is what I have so far
Stealth 8445 Feb 20, 2003, 9:31 AM
Thread; hot thread Re: [Stealth] Re:Update here is what I have so far
briski00 8394 Feb 20, 2003, 2:54 PM
Thread; hot thread Re: [briski00] Re:Update here is what I have so far
dregs2 8403 Feb 21, 2003, 4:15 AM
Post; hot thread Re: [dregs2] Re:Update here is what I have so far
briski00 8275 Feb 21, 2003, 5:54 AM
Post; hot thread Re: [Stealth] Re:Update here is what I have so far
Alex 8282 Feb 21, 2003, 11:33 AM