Use Case statement instead of Where

Please give me an example using case statement.Having Issues with Where clause…

Thanks,

Prasad


kprasadreddy (BOB member since 2004-07-02)

CASE WHEN SEARCH='I DID' THEN 'Good Boy' ELSE 'Naughty Boy' END

:rotf:


Eileen King :us: (BOB member since 2002-07-10)