IF/CASE Statement SQL
<p>I am unsure how to code this. Here are the scenarios I am needing in the IF statement. Should this be broken up into two different IF statements or could I possibly use CASE? I am new to programming so any help would be appreciated. </p>

<p>Scenerios:  IF selling_flag = 'N' and calculation_flag = 'Y' THEN return list_price. IF selling_flag = 'Y' and calculation_flag = 'Y' THEN return customer_price. IF calculation_flag = 'N' THEN return unit_selling </p>

<p>Currently I have: </p>

<pre><code>IF selling_flag = 'N' AND calculation_flag = 'Y' THEN
  return list_price;
ELSE  
  return customer_price;      
END IF; 

IF calculation_flag = 'N' THEN
return selling_price;
END IF; 
END;
</code></pre>

<p>Thank you. </p>