And just to mix it up you can place an IF within Select or a Select within an IF

However I generally agree with Les on this if you're asking a few things but only one can be correct I'd use SELECT - you could do the same thing with IF but just not as clean (IMHO)