How to convet IIf in access query to sQL query

N

NUTAN

Hi,
I have a query in Access as follows:
IIf([Time_Staged] Is Null,[Time_ArrivedAtScene],[Time_Staged]) AS
TimeAtScene,

I want to convert this query such that it can be executed in SQL server.
Thanks for the help in advance.
Nuthan
 
M

Michel Walsh

Hi,



COALESCE( time_stages, time_arrivedAtScene)


COALESCE retruns the first not null argument of the list (may have more than
two arguments). If none is not-null, returns null.


Hoping it may help,
Vanderghast, Access MVP
 
Top