>I am building a QBE type form. There are 8 fields that the user might enter data into. If they enter data into the field, then I want to include that field in the where clause. Can you use IF's when building the stored procedure?
>
>Thank
>
>Kirk
Yes, you can. You can build a select command as a string and than execute it using T-SQL command EXECUTE or system stored procedure sp_executesql.
--sb--