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