Adding A Category Column Based On A Calculation

Hi all,

I have a large dataset (currently 131,000 rows) that looks similar to the following:

ID NewPer NewAmt OldPer OldAmt
334 1/07/08 200 22/01/08 200
2396 1/07/08 4000 10/12/07 3600
7650 1/07/08 1100 07/07/06 1200
.
.
.

and I need to create a session temp table (eg ##output) that translates the calculation (NewAmt - OldAmt) into categories such as

"decrease -201 to -500"
"decrease -1 to -200"
"no change"
"increase 1 to 200"
"increase 201 to 500"

so that my final output would look like this:

ID NewPer NewAmt OldPer OldAmt Change ChangeCategory
334 1/07/08 200 22/01/08 200 0 no change
2396 1/07/08 4000 10/12/07 3600 400 increase 201 to 500
7650 1/07/08 1100 07/07/06 1200 -100 decrease -1 to -200
.
.
.
I understand how to add the "Change" column to my temp output table, but am struggling with the ChangeCategory column - can someone point me in the right direction?

Thanks in advance
Jamie