SELECT PADR(LEFT(ALLTRIM(Corp.corpname),89) + " (" + LEFT(Custody.corpnbr, 9) + ")", 100) AS corpnamnbr,; LEFT(Custody.corpnbr,9) AS corpnbr,; PADR(LEFT(ALLTRIM(Corp.corpname),100),100) AS corpname,; PADR(LEFT(ALLTRIM(Cu.cuname),100),100) AS cuname,; LEFT(Custody.cunbr,9) AS cunbr,; PADR(IIF(LEFT(Cusip.poolnbr,2) =" TC", "Transferable Certificates"," Security Holdings"),50) AS holdingtype,; LEFT(Custody.secnbr,3) + "-" + SUBSTR(Custody.secnbr,4,4) + "-" + RIGHT (Custody.secnbr,3) AS secnbrprt,; PADR(LEFT(Cusip.fedwiredes,100),100) AS fedwiredes,; Custody.face AS face, Cusip.maturedte AS maturedate,; Custody.setdte AS setdate, Cusip.coupon AS coupon,; PADR(LEFT(Cusip.Cusip,50),50) AS Cusip,; LEFT(ALLTRIM(Cusip.poolnbr),6) AS poolnbr,; PADR(Custody.FORM,50) AS secform,; PADR(Custody.location,50) AS location,; PADR(Custody.arbit,50) AS arbit,; IIF(Cusip.sectype => "060" AND Cusip.sectype <= "099",.T.,.F.) AS mbs,; PADR(Cusip.sectype,50) AS sectype,; PADR(Custody.Cusip,50) AS custodycusip,; IIF(Custody.sold = .T.,.T.,.F.) AS sold, Custody.tradenbr AS tradenbr; FROM ; c:\PROD\si\DATA\custdy Custody ; INNER JOIN c:\PROD\si\DATA\cusip Cusip ; ON ALLTRIM(Custody.Cusip) = ALLTRIM(Cusip.Cusip) ; INNER JOIN c:\PROD\si\DATA\cu Cu ; ON Custody.cunbr = Cu.cunbr ; INNER JOIN c:\PROD\si\DATA\corp Corp ; ON Custody.corpnbr = Corp.corpnbr; WHERE LEN(Custody.tradenbr) > ( 0 )