Semicolons as parameter separator in functions

Kowalski

Registered User.
Local time
Today, 14:59
Joined
Jul 5, 2007
Messages
121
I used to use commas as a parameter separator, but for some reason it is now a semicolon. How can I change it back to a comma?

Currently this works:
Code:
SELECT IIF(MyExpression; TrueThing; FalseThing)
FROM ...

Want to use (and have used before):
Code:
SELECT IIF(MyExpression, TrueThing, FalseThing)
FROM ...
 
Tx - any setting specifically? It is correct for my country and language (English - South Africa).
 
Language settings. If you were in Poland before then the settings would be different (i.e. using the semi colon). So I'm guessing South Africa uses the comma.
 

Users who are viewing this thread

Back
Top Bottom