RE: Changing sorting criteria

How about common table expression:

With t1 as (
Select MNUser, MNName, MNOpt#, MNTitl, MNDesc, MNPgm, MNCmd, MNNew,
case MNName 
  when 'MAIN' then 'A' 
  else MNName 
end as sorter 
from menu3pf 
order by MNUser, Sorter, MNOpt#
)
select MNUser, MNName, MNOpt#, MNTitl, MNDesc, MNPgm, MNCmd, MNNew from t1

Elvis

-----Original Message-----
 Subject: SQL: Changing sorting criteria

Given the following QMQRY:

Select MNUser, MNName, MNOpt#, MNTitl, MNDesc, MNPgm, MNCmd, MNNew,
case MNName 
  when 'MAIN' then 'A' 
  else MNName 
end as sorter 
from menu3pf 
order by MNUser, Sorter, MNOpt# 

which sorts 'MAIN' before 'ACCT01'

is there a way to not display SORTER?  So far, I've not bothered with 
QMFORM's.

Rob Berendt