to identify the value 0 before division in a sql

[pol]

How I can decode statement for the following sql

select ( profit_2008 / sales_2008) *100 as margin_2008
from tbl_sales

I need to find out margin_2008 when the value sales_2008 > 0 . Is there
any decode statement in sql using Access.

Please let me a help

With thanks and regards

Polachan

 

[Stefan Hoffmann]

hi Polachan,

pol wrpte:

select ( profit_2008 / sales_2008) *100 as margin_2008
from tbl_sales

I need to find out margin_2008 when the value sales_2008 > 0 . Is there
any decode statement in sql using Access.

Use Iif():

SELECT
Iif(sales_2008 <> 0, profit_2008 / sales_2008, 0) * 100
FROM tbl_sales


mfG
--> stefan <--

 

[pol]

thanks very much

hi Polachan,

pol wrpte:
Use Iif():

SELECT
Iif(sales_2008 <> 0, profit_2008 / sales_2008, 0) * 100
FROM tbl_sales


mfG
--> stefan <--