Welcome to the list! :o) And thanks for that!
Just worked out what I wanted to do via Decode.. but i'll keep that gem tucked away too! Mark > Spike <[EMAIL PROTECTED]> wrote: > > 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/ -- ICQ: 3094740 [EMAIL PROTECTED] --- 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/
