• Hi,

    sorry I forget about passing parameters..

    chk this one, hope this one helps -

    IF (@p = 'NULL' OR @p IS NULL)

    BEGIN

    SELECT * FROM abc WHERE name1 IS NULL

    END

    ELSE

    BEGIN

    SELECT * FROM abc WHERE name1 LIKE @p

    END

    _______________________________________________________________
    To get quick answer follow this link:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/