Computed column in view

[siraj777]

Hi,

Iam working in Sql Server / PowerBuilder
and I created the view like below:

create view abc as
SELECT DISTINCT (CASE WHEN dbo.resources_detail.cctr IS NULL THEN dbo.resources.cctr_master ELSE dbo.resources_detail.cctr END) cctr,
FROM dbo.resources, dbo.resources_detail
WHERE dbo.resources.resources_id *= dbo.resources_detail.resources_id

select * from abc where cctr = '123' --> simply ignored? (returns all the rows irrespective of cctr = 123), Please help.

Thanks.Siraj.