Follow up on Powerschool DECODE statements

I would like to thank Roger Sprik at the PowerSchool User Group (http://tech.groups.yahoo.com/group/PSUG/)for helping me solve my problem. He did it by thinking smarter not harder.

I was on the right track with the decode statement. Here was Roger's solution:

You can use decode a little more creatively, taking advantage that you can have an "else" statement... since you only seem to need to do school 100 differently, just make the others the "else". Also take into account that you can apply decode only to the part where there is a difference, which will take the semicolons outside of the decode...

<meta equiv="Refresh"
content="1;URL=/guardian/~(decode;~(schoolid);100;schedule;home2).html">

Thanks Again