| MySQL doesn't have a decode. That's an Oracle specific function. I believe MySQL does support an if statement, but I'd have to look at the syntax to see if it could do what you want.
__________________ It takes 2 points to draw a straight line, but at least 3 points to draw a conclusion. |