I Can't seem to get LIKE to work in a stored procedure.  For instance this
sql works in a query...

SELECT     username, approle, billingcustomer, emailredundant, groupadmin,
branch, nakey, companyadmin, bcstring, dateapproved
FROM         users
WHERE     (branch LIKE '%%') AND (bcstring LIKE '%%') AND (dateapproved IS
NULL)
ORDER BY username

But this stored procedure returns no records when %% is supplied in the two
argumants...

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[GetUnapprovedUsers]
(
@branch nchar(4),
@bcstring nvarchar(20)
)
AS
SET NOCOUNT ON;
SELECT     username, approle, billingcustomer, emailredundant, groupadmin,
branch, nakey, companyadmin, bcstring, dateapproved
FROM         users
WHERE     (branch LIKE @branch) AND (bcstring LIKE @bcstring) AND
(dateapproved IS NULL)
ORDER BY username

Anyone know why?
Thanks,
Gary