>I just ported my data to SQL Server 6.5 and I was wondering if there is any substitute for the IIF() that I used in a few views. For example: Select Site_ID,IIF(Flag="X","Passed","Failed") From xTable.
>
>Any clues are appreciated. tia
Use 'CASE' (I am not sure that I remember right syntax) :
Select 'newfield'=CASE When Flag="X" Then "Passed" Else "Failed" End
From xTable
Edward Pikman
Independent Consultant