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 |
---|---|---|---|
Order by last three numbers of five numbers | briski00 | 8742 | Feb 19, 2003, 3:57 PM |
Re:Update here is what I have so far | briski00 | 8453 | Feb 20, 2003, 8:27 AM |
Re: [briski00] Re:Update here is what I have so far | Stealth | 8445 | Feb 20, 2003, 9:31 AM |
Re: [Stealth] Re:Update here is what I have so far | briski00 | 8394 | Feb 20, 2003, 2:54 PM |
Re: [briski00] Re:Update here is what I have so far | dregs2 | 8403 | Feb 21, 2003, 4:15 AM |
Re: [dregs2] Re:Update here is what I have so far | briski00 | 8275 | Feb 21, 2003, 5:54 AM |
Re: [Stealth] Re:Update here is what I have so far | Alex | 8282 | Feb 21, 2003, 11:33 AM |