I want your idear and solving !!!

[Golden Jing]

Suppose I have a table tblEmpStop EmpID Date Reason -------------------------------------------- 1 01/01/2009 Fi 2 03/01/2009 Rs 3 03/01/2009 TS I want to make a view/query which take from tblEmpStop n replace in Coluem Reason EmpID Date Reason -------------------------------------------- 1 01/01/2009 Fired 2 03/01/2009 Resigned 3 03/01/2009 Temporary Stop I use Ms SQL Server 2000 with source code: SELECT EmpID, [Date], IF Reason = Fi, Fire; elseif Reason = Rt, Retired; elseif Reason = Rs, Resigned AS ReasonStop FROM dbo.tblEmpStop but it did not work... How can i do what i want above ? Thanks you before hand Best regard, Sovann

VB.Net

[Wendelius]

Its easiest to use CASE[^]. So your query would be like:

SELECT EmpID,
[Date],
CASE Reason
WHEN 'Fi' THEN 'Fire'
WHEN 'Rt' THEN 'Retired'
...
END AS Reason
FROM dbo.tblEmpStop

The need to optimize rises from a bad design.My articles[^]

[Golden Jing]

Thanks your for your help. But when i run it show message like: The Query Designer does not support the CASE SQL construct. But it was work... :-) Thanks you again..

VB.Net