If I understand, you are getting the criteria from a list box from a screen.
My suggestion is:
create procedure [dbo].[query] @ProgramType char(1), @AccountName char(1), @ProgramStatus char(1)
as
select ProgramId ProgramType AccountName ProgramName ProgramBudget ProgramStatus
from <table>
where ProgramType like @ProgramType
and AccountName like @AccountName
and ProgramStatus like @ProgramStatus
If in your list box you make the ALL selection have a value of % then it will act as a wildcard in the stored procedure.
Jeremy