Take two fields and manipulate into one

[tammy]

I would like to take two fields and manipulate the information into one.

Example:

SELECT
EMPCURRPOSN.PERM_IND,
EMPCURRPOSN.FT_IND
I would like to combine these two fields like below but cannot fiqure out how to do this. Would a decode work?
IF (EMPCURRPOSN.PERM_IND = '1' and EMPCURRPOSN.FT_IND = '1' then 'FULL TIME')
FROM
EMPCURRPOSN

Any idea's??

[ronverdonk]

CREATE TEMPORARY TABLE temp (remark CHAR(10));
INSERT temp (remark) VALUES('FULL TIME');
SELECT 
EMPCURRPOSN.PERM_IND, EMPCURRPOSN.FT_IND, remark
FROM EMPCURRPOSN, temp
WHERE EMPCURRPOSN.PERM_IND = '1' 
AND EMPCURRPOSN.FT_IND = '1'

Ronald :cool:

[tammy]

Thank you for the information :) However, when I try this it does not work. We are working with a new program and it does not seem to accept alot of the more complex statements. We seem to have to do work arounds alot. Do you have any other suggestions?

[ronverdonk]

I am somewhat amazed. What does not work here? These are some very simple (sort of join) MySql statements. What db are you using?

Ronald :cool: