Re: SQL Order

"Lucas" <Lucas_44_at_hotmail.com> wrote:
> Hi all,
>
> I want my query result to be in the same order as my codes that I set:
>
> Ex:
>
> select * from
> Emp
> where empcode in (810,974,603,648)
>
> The result is not at all in this order? Any suggestions on why? Or is
> there a better way of doing this?

select * from Emp where empcode=810;
select * from Emp where empcode=974;
select * from Emp where empcode=603;
select * from Emp where empcode=648;

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
                    Usenet Newsgroup Service