-- Wacky Sort Order Test
-- Create a table of data
create table #fiscal(fldYear int, fldStage int)

-- Populate the data
declare @c int
set @c = 0

while @c < 400
begin
  insert into #fiscal(fldYear, fldStage)
    select 2005, case when @c > 200 then 4 else 2 end
  set @c = @c + 1
end


-- Queries
-- Note that the calculated field is named the same
-- as the table field
select cast(P.fldYear as varchar) + case when P.fldStage > 2 then ' Final' else ' Initial' end as fldYear 
FROM #fiscal P order by P.fldYear, P.fldStage


-- Note the calculated field is named differently 
-- than the table field
select cast(P.fldYear as varchar) + case when P.fldStage > 2 then ' Final' else ' Initial' end as fldFoo 
FROM #fiscal P order by P.fldYear, P.fldStage


-- Note that the table field is included in the 
-- query under an aliased name
select P.fldYear as JIMMY, cast(P.fldYear as varchar) + case when P.fldStage > 2 then ' Final' else ' Initial' end as fldYear 
FROM #fiscal P order by P.fldYear, P.fldStage