[sqlite] Equivalent syntax?

[Anderson, James H \(IT\)]

What's the equivalent sqlite syntax for sybase convert function? For
example,

select distinct
        date, CDId, CDName, CDTicket,
        tradeId, tapsAccount, CDBook, coalesce(CDFid,'') CDFid,
        CDStatus, CDTradeDate, CDExpDate, CDNotional,
        CDCurr, CDSellBuy, CDType, CDExerType,
        CDEntity, CDCusip, CDSetlType, CDCredInit,
        CDSingleEntry, CDMaterialType, CDEffDate, CDPremFreq,
        CDPaymentType, CDUpfrontSetl, CDPublicInfo, CDCollReq,
        CDSpreadCurve, CDPremium, CDOptType, CDAccrue,
        CDRefPrice, CDPremiumAmnt, CDLastCoupLength, CDWhoDelivers,
        CDCollateralText, CDFactorReason, CDDefStartProt, CDDefEndProt,
        CDDefProtType,
        convert(char(80), NULL) CDComment,
        convert(varchar(100), NULL) CDEvent,
        convert(char(11), NULL) CDCurveType,
        convert(char(11), NULL) CrvShName,
        convert(varchar(90), NULL) CDRefEntity,
        convert(char(3), NULL) CDRefIndustry,
        convert(char(3), NULL) CDRefCountry,
        convert(char(4), NULL) CDRefSNP,
        convert(char(4),NULL) CDRefMoody,
        convert(char(4),NULL) CDRefMSRating,
        CDRefId
into TMP_credDerivOrig 
from credDerivOrig_C1

Thanks,

jim
--------------------------------------------------------

NOTICE: If received in error, please destroy and notify sender. Sender does not 
intend to waive confidentiality or privilege. Use of this email is prohibited 
when received in error.