G
Guest
Hi all
can someone help me to convert this "access" query:
IIf([Diff]<>0;"Error";"")
Many thanks...
can someone help me to convert this "access" query:
IIf([Diff]<>0;"Error";"")
Many thanks...
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Duane Hookom
convert to what? Netiquette suggests that you don't expect us to read your
subject in order to understand your question.
You can try:
CASE WHEN Diff <>0 THEN 'Error' ELSE '' END
subject in order to understand your question.
You can try:
CASE WHEN Diff <>0 THEN 'Error' ELSE '' END
G
Guest
Is there a way to get the query running both in Access and SQL Server?
Ricardo
"Duane Hookom" escreveu:
Ricardo
"Duane Hookom" escreveu:
convert to what? Netiquette suggests that you don't expect us to read your
subject in order to understand your question.
You can try:
CASE WHEN Diff <>0 THEN 'Error' ELSE '' END
--
Duane Hookom
MS Access MVP
--
Zirc said:Hi all
can someone help me to convert this "access" query:
IIf([Diff]<>0;"Error";"")
Many thanks...
M
[MVP] S.Clark
Looking at BOL, it shows that an IIF function exists. Maybe post the entire
SQL Statement and the error that you are receiving to see if someone can
help.
--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting
SQL Statement and the error that you are receiving to see if someone can
help.
--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting
Ricardo said:Is there a way to get the query running both in Access and SQL Server?
Ricardo
"Duane Hookom" escreveu:
You can try:
CASE WHEN Diff <>0 THEN 'Error' ELSE '' END
--
Duane Hookom
MS Access MVP
--
Zirc said:Hi all
can someone help me to convert this "access" query:
IIf([Diff]<>0;"Error";"")
Many thanks...
G
Guest
Running the NorthWind database and the following query:
SELECT ProductName, IIF(Discontinued = 0, 'No', 'Yes') AS Discontinued
FROM Products
I get the error: "Incorrect syntax near =".
What's the problem?
Ricardo
"[MVP] S.Clark" escreveu:
SELECT ProductName, IIF(Discontinued = 0, 'No', 'Yes') AS Discontinued
FROM Products
I get the error: "Incorrect syntax near =".
What's the problem?
Ricardo
"[MVP] S.Clark" escreveu:
Looking at BOL, it shows that an IIF function exists. Maybe post the entire
SQL Statement and the error that you are receiving to see if someone can
help.
--
Steve Clark, Access MVP
FMS, Inc.
www.fmsinc.com/consulting
Ricardo said:Is there a way to get the query running both in Access and SQL Server?
Ricardo
"Duane Hookom" escreveu:
You can try:
CASE WHEN Diff <>0 THEN 'Error' ELSE '' END
--
Duane Hookom
MS Access MVP
--
Hi all
can someone help me to convert this "access" query:
IIf([Diff]<>0;"Error";"")
Many thanks...
V
Van T. Dinh
I may be wrong but MS-SQL IIF is only available in Analysis Service and not
in general T-SQL.
in general T-SQL.