A. - this item does not work with Year function in SELECT CASE statement

SELECT f.EFF_DT, CASE f.END_DT WHEN YEAR(f.END_DT) = 9999 THEN 'Present' ELSE f.END_DT END
From Customer F


B. Same 'YEAR' function does work in WHERE clause.

SELECT f.EFF_DT
FROM Customer F
Where YEAR(f.END_DT) = 9999


Any thoughts, most appreciated...Thanks,
Marcel K.

You have 2 problems:

1. f.END_DT and "present" are not the same datatype.

2. Wrong syntax for case. Try this (using current date instead of "present":

SELECT f.END_DT,
CASE YEAR(f.END_DT)
WHEN 9999
THEN current date [or anything in external date format]
ELSE
f.END_DT
END
From Customer F...

However...

You can do this to get the datatypes the same:

SELECT f.END_DT,
CASE YEAR(f.END_DT)
WHEN 9999
THEN 'present'
ELSE
cast(f.END_DT as char(10))
END
From Customer F...