In oracle two other functions which could be used are NVL and DECODE. at the same time CASE is more portable, but DECODE is very powerful
z On 5/8/07, Scott Thornton <[EMAIL PROTECTED]> wrote: > > I have been using MS SQL 2000 for about 7 years now... but I had to look up > NULLIF in books online to find out what it did. > > There is always an easier way. > > >>> "Mike Kear" <[EMAIL PROTECTED]> 08/05/2007 3:30 pm >>> > > That did the trick, thanks Scott. I was trying to make it too > complicated for myself. > > "Case" was the answer. > > > -- > Cheers > Mike Kear > Windsor, NSW, Australia > Adobe Certified Advanced ColdFusion Developer > AFP Webworks > http://afpwebworks.com > ColdFusion, PHP, ASP, ASP.NET hosting from AUD$15/month > > > > On 5/8/07, Scott Thornton <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > This is how I might do it in SQL Server: > > > > SELECT > > > > SUM(CASE WHEN deliverymethod = 'F' THEN > > 1 > > ELSE > > 0 > > END) AS FAXES, > > SUM(CASE WHEN deliverymethod = 'E' THEN > > 1 > > ELSE > > 0 > > END) AS EMAILS > > FROM > > EReferralDailyMailoutHistory g INNER JOIN > > DeliveryStatusMaster d ON > > g.deliverystatus = d.statuscode > > AND > > g.deliverydate > #createodbcdate(arguments.argsStartDate)# > > AND > > g.deliverydate < #createodbcdate(arguments.argsEndDate)# > > > > > > perhaps this will give you an idea of an alternate method of using NULLIF > > and are now able to find the Oracle equivlalent of CASE. > > > > > > > > > -- Zac Spitzer +61 405 847 168 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en -~----------~----~----~----~------~----~------~--~---
