Are you sure? I checked MySQL before posting

Post #204,399 by SpiceWare 4/22/05 9:54:09 AM Reply	Are you sure? I checked MySQL before posting I put decode in the search box at [link\|http://www.mysql.com/\|MySQL.com]. The first result was [link\|http://dev.mysql.com/doc/maxdb/en/cf/63316bc03511d2a97100a0c9449261/content.htm\|DECODE(x,y(i),...,z)] with sample code SELECT hno, price, DECODE (type,\n'single', 1, 'double', 2, 'suite', 3) room_code\n FROM room\n WHERE hno IN (40,50,60) As such, I figured it supported decode and posted my example for Drew. Darrell Spice, Jr. [link\|http://spiceware.org/gallery/ArtisticOverpass\|Artistic Overpass]\n[link\|http://www.spiceware.org/\|SpiceWare] - We don't do Windows, it's too much of a chore
Post #204,416 by ben_tilly 4/22/05 11:16:56 AM Reply	They may have added it but it is not standard If they did add it, I don't know which version it would have been. I know that when I went searching for it, I was pointed at a conversion from Oracle's DECODE to MySQL's CASE. (Which doesn't seem like it quite matches the SQL-92's standard for CASE either. Oh well.) Cheers, Ben I have come to believe that idealism without discipline is a quick road to disaster, while discipline without idealism is pointless. -- Aaron Ward (my brother)
Post #204,423 by JayMehaffey 4/22/05 11:35:10 AM Reply	Seems to be specific to MaxDB MaxDB is the databsse MySQL got when they partnered with SAP. It does have an Oracle like decode. MySQL has a function called decode, but it an encryption function that works opposite encode. Jay
Post #204,435 by SpiceWare 4/22/05 12:14:55 PM Reply	That's rather confusing odd that the MaxDB version of Decode would come up first on a MySQL site search. Oh well. Darrell Spice, Jr. [link\|http://spiceware.org/gallery/ArtisticOverpass\|Artistic Overpass]\n[link\|http://www.spiceware.org/\|SpiceWare] - We don't do Windows, it's too much of a chore

Welcome to IWETHEY!