Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-09-18 : 00:36:05
|
Wouter writes "Hi,
I have a question about the conversion from an Access query to SQL Server (7).
In my old query I have something like this
SELECT iif(disID=0,disMainID,disID) as disNewID .... and so on
Now I tried to use the same query in SQL Server, no luck of course.
Can you give me an answer how to convert these 'old' queries?
Thanks,
Wouter"
|
|
|
|
|
|
The use of IF..THEN...ELSE to determine which field to use