>>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
That may do the trick!
Thanks! {:-)
Steve Medvid
Systems Analyst
Environmental Resource Management