if/else in SQL

[Ali29J]

Hi All

I am trying to use SQL to run a calculation, at the moment it is:

calculatedtotal2: [QuoteFinish]-[QuoteStart]

but i would like in if/else statement, if [QuoteFinish] is null then

calculatedtotal2: [todaysdate??]-[QuoteStart]

So in VB code it would be:

if isnull(me.quotefinish.value) then
calculatedtotal2 = [Date()]-[QuoteStart]
else
[QuoteFinish]-[QuoteStart]

is this possible in SQL? or can anyone assist in converting ths above to SQL not sure on SQL coding...

Thanks

Ali

 

[PHV]

calculatedtotal2: Nz([QuoteFinish],Date())-[QuoteStart]

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886