Building A Dynamic Stored Procedure

Hi


I am in the very final stages of
building a dating app for a client, I am totally stuck with the
advanced search page. been googling for days with limited success


For the most basic of purposes I have added a few form fields to my search.aspx page;

county (Dropdown list)

min age (Dropdown list)

max age (dropdown list)

Smoker (check box)

keyword (textbox)


My codebehind passes the vars to a stored procedure

@county = me.county.selectedvalue

etc

My problem is the stored procedure I sort of have the following but I can't get it to run

<code>

ALTER PROCEDURE dbo.TEST_ADVANCED_SEARCH

(@countyID int ,

@MaxAge
varchar(100),

@MinAge
varchar(100),



@smoker tinyint),

@keyword
varchar(250))



AS


DECLARE @SQL Varchar
(4000)


SELECT  @SQL =   'dbo.user_accounts.profileComplete,

dbo.user_accounts.countyID, dbo.user_profiles.smoker,

dbo.user_profiles.Age

FROM         dbo.user_accounts INNER
JOIN

                     
dbo.user_profiles ON dbo.user_accounts.userID =

dbo.user_profiles.userID

WHERE     (dbo.user_accounts.profileComplete =
1)'


IF @countyID > 0

SELECT @SQL = @SQL + ' AND
(dbo.user_accounts.countyID = @countyID)'


IF @MaxAge IS NOT
NULL

SELECT @SQL = @SQL + ' AND (dbo.user_profiles.Age <= @MaxAge)
'


IF @MinAge IS NOT
NULL

SELECT @SQL = @SQL + ' AND (dbo.user_profiles.Age >= @MinAge)
'




IF @smoker > 0

SELECT @SQL = @SQL + ' AND
(dbo.user_profiles.smoker = 1)'


IF @keyword IS NOT
NULL

SELECT @SQL = @SQL + ' AND (dbo.user_profiles.Description LIKE @MinAge)
'




EXEC(@SQL)

</code>
If I can get this to work I can add the remaining fields that I need

Am I Missing something glaringly obvious?
Any help or advice gratefully received

Thanks