I want to create a 'view' but have a condition on a column based on another
column. Basically, I want to do this:

CREATE VIEW MyView
AS
SELECT [id] AS dept_id,
[name] AS dept_name,
url WHEN STATUS = 'ACTIVE'
FROM department
WHERE event_sharing = 'on'


What I want to do is only display the URL field when the Status = 'Active',
and if Status <> 'Acitve' I want to return a null/blank URL field.

You can use a CASE expression like:

SELECT id, name,
CASE status WHEN 'Active THEN url END AS url
FROM dpt
WHERE ... ;

--
- Anith
( Please reply to newsgroups only )

Thank you ... that is exacting what I was looking for


"Anith Sen" <anith (AT) bizdatasolutions (DOT) com> wrote