Re: SQL and Order By Question

If you are forced to hardcode your sort order if might be easier to use the posstr function instead of a Case when statement. See example below:

Select
sample,
posstr( 'acdbefghijklmnopqrstuvwxyz', sample ) as Sort
From
( Select 'a' as sample from Sysibm.Sysdummy1
Union Select 'b' as sample from Sysibm.Sysdummy1
Union Select 'c' as sample from Sysibm.Sysdummy1
Union Select 'd' as sample from Sysibm.Sysdummy1 ) as fields
Order By 2



Michael_Schutte@xxxxxxxxxxxx wrote:
That's the point... :-) That's why I try to post anywhere I can help...


Michael Schutte
Admin Professional
Bob Evans Farms, Inc.
"The Secret's the Sauce! Enjoy our new Bob-B-Q Pulled Pork Knife & Fork
Sandwich!"


java400-l-bounces@xxxxxxxxxxxx wrote on 07/30/2007 02:45:22 PM:

Every blasted time Michael posts a message I get hungry :) j/k.... look

at

the sig lol....

Ron Power
Programmer
Information Services
City Of St. John's, NL
P.O. Box 908
St. John's, NL
A1C 5M2
709-576-8132
rpower@xxxxxxxxxx
http://www.stjohns.ca/