Conditional expressions in SQL Server

[George99]

Hi all

I am struggling here without manuals. I want to write a simple SQL statement like

SELECT
customerid,
customertype,
orderid,
ordertotal,
iif(customertype="A",.1,.2) as discountrate,
ordertotal * discountrate as discounttotal
FROM
salesorder

etc etc


Thanks for your help

George


George Allard
Crystal Reports Consultant and Trainer

http://www.crystal-technical-services.co.uk

 

[bdreed35]

try this:

SELECT
customerid,
customertype,
orderid,
ordertotal,
(case customertype when 'A' then 0.1 else 0.2 end) as discountrate,
ordertotal * discountrate as discounttotal
FROM
salesorder

~Brian