Show quoted text 6 lines
On Tue, 2 Feb 2016, Michael Van Canneyt wrote:
At least Firebird & Microsoft SQL Server and MS-Access contain it.
FastReport uses it.
I use this since 15+ years, I didn't make up this name myself:-)
These products (remember Excel too) use managed code. Also, in SQL Server/FB/Access the functions are integrated into declarative language.
The calculating order of arguments in IIF is not defined, the query optimizer select the good plan (control of flow).
Regards,
Serguei