SELECT CAST(CL.CPF AS VARCHAR(14)) AS CPFCNPJ, CAST(CL.RG  AS VARCHAR(20)) AS RGIE, CL.DATANASC AS NASCFUNDACAO,
  CAST('' AS VARCHAR(70)) AS RAZAO
  FROM CLIENTEFISICO CL
  WHERE CL.CODCLIENTE=:CODCLIENTE
UNION ALL
  SELECT CAST(CJ.CNPJ AS VARCHAR(14))AS CFPCNPJ, CAST(CJ.IE AS VARCHAR(20))AS RGIE, CJ.DATAFUNDACAO AS NASCFUNDACAO,
  CAST(CJ.RAZAO AS VARCHAR(70)) AS RAZAO
     FROM CLIENTEJURIDICO CJ
    WHERE CJ.CODCLIENTE=:CODCLIENTE