[etravels]

Hi all

Can someone tell me how to use the decode in the following;

I want to set up decode statement in a select query for the following

Select contact.contact_reference||','||
contact.original_owner_id||','||
contact_x.d1
decode(contact.status.type,2,' ')-1)||','||

I want to to return values for --contact.status_updated only when contact.status_type=2 otherwise leave blank...



contact.contact_method_id||','||
contact.created ||','||
contact.status_type||','||
contact.original_group_id||','||
contact.current_owner_id||','||
contact.created_by
from contact


would I use decode

cheers
E

[ss659]

select
decode(status_updated, 2, status_updated, null)
from table

[ss659]

Ignore the first post - didnt read it correctly

select
decode(status_type, 2, status_updated, null)
from table