Thanks all! I knew it had to be something silly like that.

DM

Here is the code for my SPROC., it skips over every "IF" statement regardless of the value of the parameter:

ALTER PROCEDURE [dbo].[filtersortlikeDGV]

@SrtBy NVARCHAR(20),

@ItmType NVARCHAR(20) = 'All Items',

@CatName NVARCHAR(20) = 'All...