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