Using MS Sql Server 2008.
My table has field name DCode1, DCode2, DCode3, DCode4, DCode5. The values of all these DCode fields is either 'F1' or 'F7'.
I want to write a select statement with the following constraint:
When any DCode value is F1 then Go in F1, if DCode value is 'F7', then go in F7.
Select ???? as F1, ???? as F7.............How do I do that?