On 1/31/07, Anderson, James H (IT) <[EMAIL PROTECTED]> wrote:
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
Are you looking for something like ifnull or nullif?
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.
-- Puneet Kishor http://punkish.eidesis.org/ Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/ Open Source Geospatial Foundation http://www.osgeo.org/education/ --------------------------------------------------------------------- collaborate, communicate, compete ===================================================================== ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
