RE: SQL - Using Case in Order By clause

Hi,

>Your solution only will work if EMEMP# is a character field, too.
>To handle different datatypes, you have to use different Case statements.

I kind of lucked out, in that both EMEMP# & the name fields are alpha
(different lengths, but both defined as alpha). I didn't realize you could
do multiple Case statements like that.  I will keep that in mind, because I
can see using this technique again. I can't believe how slick it worked
compared to the way you used to have to do this in older versions, before
SQL.

<===================================================>

Terri Harteau
Felker Brothers Corporation
****************
Paperwork is like kudzu. Both need to be pruned regularly. Usually, a
flamethrower is overkill.      Usually.
****************