Oracle Java Case like If Else SQL

String  sql = "SELECT  CASE WHEN contract_active_for ='General' THEN 'General contact data for customer branch (overrides company setting)' ELSE TRIM(contract_active_for || ' ' || '(overrides company setting)') END as Assignment ,ref as Reference, TRIM(name ||' '|| name2) as \"Full Name\", phone as Phone, phone2 as \"Sec Phone\",fax as Fax, email from crm_persons where branch_id='"+ br_id+"'";