Hi, I want some help using CA

[mukund]

Hi,
I want some help using CASE in the select statement.

select
ISgroup =
CASE p.GroupId
WHEN NULL THEN "NO"
ELSE "YES"
END
from POHead p

In this SQL statement I don't get the desired results.
The SQL does not work for NULL values in the GroupId field.

Anybody has a solution for this.

Regards,
Mukund.

 

[tlbroadbent]

Make a slight correction.

SELECT
ISgroup =
CASE
WHEN p.GroupId IS NULL THEN "NO"
ELSE "YES"
END
FROM POHead p
Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[mukund]

Hi Terry,

Thanks a lot.

Mukund.