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