Conditional field in SQL query

[Dewald]

Could someone help me with this one perhaps? Let's say I have a simple SQL query like:

SELECT EmployeeID, EmployeeName, YearStarted FROM Employees

I'd like to return a fourth column in the result set of which the value is conditional upon the value of another column. For instance, if the value of YearStarted is older than 2007, return 'veteran' otherwise return 'spring chicken'. I'm thining something like:

SELECT EmployeeID, EmployeeName, YearStarted, IF(YearStarted<2007,'Veteran','Spring Chicken') FROM Employees

but obviously such an IF statement doesn't exist in SQL. Is there another way to do it?

[R Giskard Reventlov]

select
EmployeeID,
EmployeeName,
YearStarted,
case
when YearStarted < 2007 then 'Veteran'
else 'Spring Chicken'
end NewColumn
from
Employees

me, me, me "The dinosaurs became extinct because they didn't have a space program. And if we become extinct because we don't have a space program, it'll serve us right!" Larry Niven

[Dewald]

Excellent! Thanks a mil.