How to convet IIf in access query to sQL query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top