Date Comparing in SP

See more:

SQL-Server-2005

SQL-Server

I'm using the Following:

ALTER procedure [dbo].[searchEstimate1] (@p_serchStr nvarchar(30), @v_done smallint OUTPUT)
as
DECLARE @SerchValueIDTBL TABLE (SerchValueID bigint)

BEGIN
    SET @p_serchStr = UPPER('%'+@p_serchStr+'%')
    delete from @SerchValueIDTBL

    SET @v_done = 1

insert into @SerchValueIDTBL
    select EstimateID
    from EstimateMaster
   where UPPER(convert(varchar(50),EstimateDate))like @p_serchStr



SELECT *
    FROM EstimateSummary
    where EstimateID IN ( select distinct SerchValueID
                          from @SerchValueIDTBL)


    SELECT @v_done
END

in this when i Pass the date that is jun two space 2 2010 then its takes
and when May two space 22 2010 then it does not display