Is there an equivalent method in Transact-SQL that emulates the conditional IF statement in Access97 BASIC?
eg
SELECT
ID,
IIF([ID]=1,"Chips","Peas" AS Status
From
tblTest
returns:
Valid Status
--------- -----------
1 Chips
3 Peas
4 Peas
Thanks