Hi,
Iam trying to extract certain fields from a table.
Suppose I have a table with three fileds
Shipper, Receiver and type

My query should return rows with one column such that if
type is 1, it should return flat string "TYPE 1", otherwise, it should return Receiver.
Suppose my data is like

"Shipper1", "Receiver1", 1
"Shipper2", "Receiver2", 2
"Shipper3", "Receiver3", 1

And the query should return
"TYPE 1"
"Receiver2"
"TYPE 1"

How to write an sql query for this?

Thanks
Puri