Hi,

  I ve two fiedls like
ex:
ename, designation.
george A ---->(record)
paul M ---->(record)
I n designation i ve mentioned A (means Accountant) M (means Manager)
I want to dislay the result as

ex:
ename designation
george Account
paul Manager

Pl help me..

select name, case designation when 'A' then 'Accountant' else 'Manager' end as designation from table

Don't you have a lookup table for this???

http://sqlservercode.blogspot.com/

You can use a CASE statement for this if you don't have a table that contains what they mean:

SELECT ename, CASE Designation WHEN 'A' THEN 'Accountant' WHEN 'M' THEN 'Manager' ELSE 'Unknown' END AS Designation
FROM YourTable

SQL Server Helper
http://www.sql-server-helper.com

You can use a Case statement but you "should" use a lookup table as previously described. It's a better habit to get into.