Help With Query (control Structure + Regex)

Hi,

I have the following query I am bulding, its returning the desired results I am just really bad at control statements in TSQL.

What I want to do is dynamically pass the "and landingPage like '/products%' to the SPROC. If I pass nothing this part of the query is not added.

Also, I am wondering how difficult it would be to pass some RegEx into the "landingpage like '%asdf' " part of the query ?
I have started reading some articles but it seems pretty complicated. I am running sql2005 so I am clear on that part.

Any help is much appreicated!!

Thanks again,
mike123




CREATE PROCEDURE [dbo].[select_google_referrers_groupByQueryDate_OrderByQueryDate]

(
@numDays int,
@landingPage varchar(50) = NULL
)

AS SET NOCOUNT ON

SELECT CONVERT(varchar(10),GO.queryDate,112) as referDate,

COUNT(GO.queryID) AS TotalReferrers FROM tblgoogle_referrerDetails GO

WHERE DateDiff(dd, GO.queryDate, GetDate()) < @numDays and landingpage like '/products%'

GROUP BY CONVERT(varchar(10),GO.queryDate,112)

ORDER BY referDate DESC
GO