Order By- CREATIVITY NEEDED!

Greetings,
I want to order by Orders then RecType, BUT leaving RecType=13 in
between 30 and 40. So the sequence should be: 10, 15, 30, 13, 40 for
Order=4501130 then Order=5006730.
CREATE TABLE TblA (RecType int, Orders varchar(255))
INSERT INTO TblA (RecType, Orders) VALUES (10, '4501130')
INSERT INTO TblA (RecType, Orders) VALUES (10, '5006730')
INSERT INTO TblA (RecType, Orders) VALUES (15, '4501130')
INSERT INTO TblA (RecType, Orders) VALUES (15, '5006730')
INSERT INTO TblA (RecType, Orders) VALUES (30, '4501130')
INSERT INTO TblA (RecType, Orders) VALUES (30, '5006730')
INSERT INTO TblA (RecType, Orders) VALUES (13, '4501130')
INSERT INTO TblA (RecType, Orders) VALUES (13, '5006730')
INSERT INTO TblA (RecType, Orders) VALUES (40, '4501130')
INSERT INTO TblA (RecType, Orders) VALUES (40, '5006730')
SELECT * FROM TblA ORDER BY Orders ASC, RecType ASC
--
Thanks in Advance,
Don
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!SELECT * FROM TblA
ORDER BY Orders ASC,
Case RecType When 13 Then 35 Else RecType End ASC
"don larry" wrote:

> Greetings,
> I want to order by Orders then RecType, BUT leaving RecType=13 in
> between 30 and 40. So the sequence should be: 10, 15, 30, 13, 40 for
> Order=4501130 then Order=5006730.
> --
> CREATE TABLE TblA (RecType int, Orders varchar(255))
> INSERT INTO TblA (RecType, Orders) VALUES (10, '4501130')
> INSERT INTO TblA (RecType, Orders) VALUES (10, '5006730')
> INSERT INTO TblA (RecType, Orders) VALUES (15, '4501130')
> INSERT INTO TblA (RecType, Orders) VALUES (15, '5006730')
> INSERT INTO TblA (RecType, Orders) VALUES (30, '4501130')
> INSERT INTO TblA (RecType, Orders) VALUES (30, '5006730')
> INSERT INTO TblA (RecType, Orders) VALUES (13, '4501130')
> INSERT INTO TblA (RecType, Orders) VALUES (13, '5006730')
> INSERT INTO TblA (RecType, Orders) VALUES (40, '4501130')
> INSERT INTO TblA (RecType, Orders) VALUES (40, '5006730')
> SELECT * FROM TblA ORDER BY Orders ASC, RecType ASC
> --
> Thanks in Advance,
> Don
>
> *** Sent via Developersdex http://www.examnotes.net ***
> Don't just participate in USENET...get rewarded for it!
>|||Wow, what a nifty little trick!
Sure worked though.
Thanks, i appreciate.
Don
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!