Re: Sort Select by List

[Pintér Tibor]

Keith Spiller írta:
> Hello,
>
> RE:  Sort Select by List
>
> I'm wondering how I would turn three different queries:
>
>     SELECT * FROM team WHERE office = 'Exec'
>     SELECT * FROM team WHERE office = 'VP'
>     SELECT * FROM team WHERE office = 'Dir'
>
> Into one query with the sort order of office = 'Exec', 'VP', 'Dir'...
> Thanks,
>
>
> Keith
>   

order by right(office,1)

or make an extra column for ordering

t