Particular record on colum which we didnt want to display

ALTER procedure [dbo].[PMP_GetGrantDonation_Type_byGD_Type_Id]

@GD_Type_Id int

as

if (@GD_Type_Id = 1)

Begin

select * from PMP_GrantDonation_Type

where gd_type_id=@GD_Type_Id and SubType_Name NOt In ( 'In Kind Donation')

order by GD_SubType_id asc

end

else

Begin

select * from PMP_GrantDonation_Type

where gd_type_id=@GD_Type_Id and SubType_Name NOt In ( 'In-kind Mission','In-kind Friends & Need','In-kind')

order by GD_SubType_id asc

end