I also like case statements as I have been using Sql server all the time, but in this job they use ORACLE and part of the query was already written...

Yes I am using Oracle, but I really like this forum and web-site as answers are always pretty simple and easy to understand:) I would appreciate if you can...