Home Forums SQL Server 2008 SQL Server 2008 - General Characters in IIF statements RE: Characters in IIF statements
rkaria
Ten Centuries
Points: 1363
More actions
January 14, 2011 at 6:33 am
#1273496
thanks, the reason I needed it as a field was so I could group, but I found if I can create a group by an expression, so I added the oringal coe =iif(Fields!COSTYPE.Value = M,"Available", "Reconciled") as a group expression and it worked!