Re: Possible to use a conditional in this UPDATE

[Scott Haneda]

on 10/28/05 5:52 AM, Brent Baisley at brent@stripped 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: [phone]
<http://www.newgeo.com>                     Novato, CA U.S.A.