There's some useful info on Oracle-Base.com http://www.oracle-base.com/Articles/9i/Case9i.asp
Hope that helps Spike p.s. Hi everybody, just arrived in OZ last week and those nice folks at Daemon suggested I subscribe to the cfaussie mailing list. Stephen Milligan Team Macromedia - ColdFusion Co-author 'Reality Macromedia ColdFusion MX: Intranets and Content Management' http://spikefu.blogspot.com > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Mark M > Sent: 24 February 2003 12:13 > To: CFAussie Mailing List > Subject: [cfaussie] [SQL] CASE Statements? > > > Heya folks, > > Anyone got a handy reference lying around for how to use CASE > statements in > SQL? > > I'm trying to do something clever via SQL (i.e. only update a > certain field if it is not > a certain value) and I'm thinking case may be the way to go. > > Also interested in other logical operators within SQL as well > - such as Decode. > > (Oracle DB here) > > If anyone has anything useful in terms of reference, I would > greatly appreciate it, > as I can't seem to find a thing! > > Cheers, > > Mark > > --- > You are currently subscribed to cfaussie as: > [EMAIL PROTECTED] To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MX Downunder AsiaPac DevCon - http://mxdu.com/ > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
