Forum Discussion
Azure Synapse Analytics Dedicated SQL pool - IIF statement Support required
Trying to use IIF() in SELECT statement and getting the error "Incorrect syntax near '>'." in Azure Synapse Analytics-Dedicated SQL pool Tried like below: SELECT IIF(1>2, 'YES', 'NO'); This(...
pawelpotasinski
Microsoft
MicrosoftIt is documented, that IIF function is not supported by Azure Synapse Analytics - the name of this platform is not present in the "Applies to" section of the IIF documentation: IIF (Transact-SQL) - SQL Server | Microsoft Docs.
HTH,
Pawel
I had to convert all my IIF statements to CASE. I am just wondering if it will be supported in the future?
Thanks
