Sharon

I would suggest never using an asterisk like that. You will only have difficulties. Also, always name your columns, never use an asterisk in your query. What happens to the front-end if a column is added to the tables, or removed?

So back to your question:

In your stored procedure, simply use an IF statement

IF @HourStated = 0

BEGIN

SELECT

<ColumnName1>

, <ColumnName2>

, <ColumnNameN>

FROM

Production

WHERE

HourWorked > 15

END

ELSE

BEGIN

SELECT

<ColumnName1>

, <ColumnName2>

, <ColumnNameN>

FROM

Production

WHERE

HourWorked >= @HoursStated

END

Andrew SQLDBA