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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to convert access query IIf([Time_Enroute] Is Not Null,IIf([P. 2
Convert Access Query to SQL2000 Query 2
How to display zero value in blank fields of Cross Tab query 0
determining if a field should be included 6
Iif then statement needed for Access 2007 please 9
#error - Blank 3
Can I save a sql statement generated by a search form? 1
Query on SQL Server is fast, while Access is crawling 2

Top