You could include all options in the SQL and use boolean expressions to turn off the ones you don't need:
<br />
SELECT ...<br />
FROM ...<br />
WHERE<br />
( @SearchType = 'Name' AND Name LIKE '%'+@SearchQuery+'%' )<br />
OR<br />
( @SearchType = 'Desc' AND Description LIKE '%'+@SearchQuery+'%' )<br />
OR<br />
...<br />
Nick