Talk:Oracle 7

From Oracle FAQ
Jump to: navigation, search

I want to use the decode function and get data back in a field. What should I do? Here is my code: decode ( PO.Description, '%RUSH%','Rush','%HURRY%','Hurry','%ASAP%','ASAP','%HOT%','HOT') AS Description_Should_Be

The field Description_Should_Be is null when the query runs.