on 10/28/05 5:52 AM, Brent Baisley at [EMAIL PROTECTED] wrote: > You can nest the IF statement, putting another where 'soon' is like > Jasper suggested. Or you can use the CASE WHEN THEN construct if you > have a lot of conditions you need to check for.
Can you show me an example of the CASE method, I tried and it would error, the docs are a wee bit confusing in that regards. -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]