Formatting bug when using IIF

eugenen

if you take the following statement, the spaces are intenional white spaces, and format it it does not format the IIF as nicely as the datediff

select 
	iif(     rrbr.ColumnName = 'Test',    0,       1), 
	datediff(       day,         getdate(),       getdate()    )
from 
	recon.ReconResultsByRow as rrbr

select 
	iif(
	rrbr.ColumnName = 'Test',    0,       1),
	datediff(day, getdate(), getdate())
from
	recon.ReconResultsByRow as rrbr

Aaron L

This'll be fixed in the next release of prompt (and is also in the private build I mentioned on your other post)