helo everyone

[nittin14]

I am facing a problem pls if u know the solution then send me.
thanks in advance
my problem is :

suppose there is a table: employee
Job_category //column name in employee table
t // data in employee table
s // data in employee table

my problem is this:
i want to show like this without editing in data in the employee table


Job_category //column name
trainig //data
scietist

[ScarletPimpernal]

Hi,

If u know the values to be shown as a static value for the value present in the DB.

Then use this query,

SELECT CASE job_category WHEN 's' THEN 'scientist' WHEN 't' THEN 'training' ELSE NULL END AS job_category FROM employee;

Thanks,
Scarlet

I am facing a problem pls if u know the solution then send me.
thanks in advance
my problem is :

suppose there is a table: employee
Job_category //column name in employee table
t // data in employee table
s // data in employee table

my problem is this:
i want to show like this without editing in data in the employee table


Job_category //column name
trainig //data
scietist

[nittin14]

Hi,

If u know the values to be shown as a static value for the value present in the DB.

Then use this query,

SELECT CASE job_category WHEN 's' THEN 'scientist' WHEN 't' THEN 'training' ELSE NULL END AS job_category FROM employee;

Thanks,
Scarlet

thanks scarlet
u query is working wonderfully
thnks again
bie