Any idea why this is telling me that the field value I want to pass in
is an invalid column name?

This is for a "Search By" query.  I have a drop down of choices and a
text box for the value.  I need to search for the value entered in the
text box in the drop down field.  The list is populated from fields in
more than 1 table.

STORED PROC:

ALTER PROCEDURE dbo.searchQuery2
    (
        @searchTxt varchar(50) = NULL, @searchField varchar(50)
    )
AS
    Declare @sql varchar(4000)
    Select @sql = 'Select r.requestID, r.projectManager, r.projectName,
r.dateSubmitted, a.Name
    From Request r, AppComm a
    Where ' + @searchField + ' = ' + @searchTxt + 'and r.reviewedBy =
a.badgeID'

    Select @sql

    exec (@sql)


OUTPUT:

Select r.requestID, r.projectManager, r.projectName, r.dateSubmitted,
a.Name
    From Request r, AppComm a
    Where sumbittedBy = a111111 and r.reviewedBy = a.badgeID


Invalid column name 'a111111'.

(1 row(s) returned)
@RETURN_VALUE = 0
Finished running dbo."searchQuery2".

Why is it returning the correct SQL but telling me that a111111 is a
column??? - it is not a column at all, it is the value.  I have tried
playing around with single and double quotes but nothing seems to work.

Please help.

Thanks!

can't delete a row from primary table - is there an SP for this?
Ranking Rows
T-SQL
Convert(datetime, '07/11/48') Returns Year 2048!!
UPDLOCK blocking readers