Filter Records

[jshanoo]

Hi all,
Please see my SQl stmt
-------------------------------------------------
Select contract,company,from_date,pin,feedback,
cast(feedback as datetime) as a2,
'Status' =
CASE
WHEN cast(feedback as datetime)> getdate() THEN 'Active'
WHEN cast(feedback as datetime) < getdate() THEN 'Expired'
WHEN cast(feedback as datetime) = getdate() THEN 'Expiring Today'
END
from maininfo
where (from_date between '04/01/2004' and '04/15/2004') and len(feedback) > 0
order by contract-----------------------------------------------
i want to filter according to 'status' field

only records with status='Active'

has to be displayed can any one please help me in this
Regards

John Philip


*** Even the Best, did the Bad and Made the Best ***

John Philip

 

[ClaireHCM]

select * from
( Select contract,company,from_date,pin,feedback,
cast(feedback as datetime) as a2,
'Status' =
CASE
WHEN cast(feedback as datetime)> getdate() THEN 'Active'
WHEN cast(feedback as datetime) < getdate() THEN 'Expired'
WHEN cast(feedback as datetime) = getdate() THEN 'Expiring Today'
END
from maininfo
where (from_date between '04/01/2004' and '04/15/2004') and len(feedback) > 0) a
where Status = 'Active' order by contract

 

[jshanoo]

hi,

But this statement will not work in sql server.

Regards
john philip

*** Even the Best, did the Bad and Made the Best ***

John Philip