SQL Case Statement Problem

[goal2007]

Here is what i am doing:

select case
when SUBSTRING(task_name, 1, 3)= 'PTO'
then Replace(task_name,'PTO','PTO_Holiday')
when SUBSTRING(task_name, 1, 7)= 'Holiday'
then Replace(task_name,'Holiday','PTO_Holiday')

when SUBSTRING(proj_name, 1, 9)= '9900-2831'
then Replace(proj_name,'9900-2831','II Internal')
when SUBSTRING(proj_name, 1, 9)= '9900-2788'
then Replace(proj_name,'9900-2788','II Internal')


Line 3 ELSE proj_name,task_name END as Task_Name




FROM dbo._Employee_Time_Detail_Reports INNER JOIN
dbo._vw_Employee ON dbo._Employee_Time_Detail_Reports.res_name = dbo._vw_Employee.Employee

This work fine, however in line THREE i need to show two columns

something like this

ELSE proj_name,task_name END as Task_Name,Project_Name

but this is worng. how can i fix that

[rob313]

You need to use two CASE statements like this:

select case
when SUBSTRING(task_name, 1, 3)= 'PTO'
then Replace(task_name,'PTO','PTO_Holiday')
when SUBSTRING(task_name, 1, 7)= 'Holiday'
then Replace(task_name,'Holiday','PTO_Holiday')
ELSE task_name
END as task_name
CASE
when SUBSTRING(proj_name, 1, 9)= '9900-2831'
then Replace(proj_name,'9900-2831','II Internal')
when SUBSTRING(proj_name, 1, 9)= '9900-2788'
then Replace(proj_name,'9900-2788','II Internal')
ELSE proj_name
END as proj_name
FROM ....

[rob313]

Opps, I forgot a comma in between the two case statements.

select case
when SUBSTRING(task_name, 1, 3)= 'PTO'
then Replace(task_name,'PTO','PTO_Holiday')
when SUBSTRING(task_name, 1, 7)= 'Holiday'
then Replace(task_name,'Holiday','PTO_Holiday')
ELSE task_name
END as task_name,

CASE
when SUBSTRING(proj_name, 1, 9)= '9900-2831'
then Replace(proj_name,'9900-2831','II Internal')
when SUBSTRING(proj_name, 1, 9)= '9900-2788'
then Replace(proj_name,'9900-2788','II Internal')
ELSE proj_name
END as proj_name
FROM ....

[goal2007]

Thank you SOOO much for your help