Re: A difficult query- urgent for me

[Jochem van Dieten]

On 1/15/06, [EMAIL PROTECTED] wrote:
>
> Actually there is a table with columns a and b .
> So i want if a contains a particular word than a's value should return else
> 'b' value should return.

SELECT
  CASE
    WHEN a = 'Good' THEN a
    ELSE b
  END
FROM
  table

Jochem