Select statement with field from used under different names depening on the values of other field in the same table

Question

Hi,

Could anybody tell me please how to write the select statement where one field can be used under different names depending on the value of other field in the same table?

Thanks