sql -- too many rows

[TRYP]

Im getting back too many rows in my SQL query.
in the following code
lookAt="title"
and
lookFor="asst mgr"

recEmps.Open "Select * from employee where (" & lookAt & " = '" & lookFor & "')", conPool, adOpenStatic, adLockOptimistic

im getting back rows where title="mgr"

am i doin something wrong or is this a natural SQL thing to search the string for an occurance of a string and not do a tru compare?

 

[swilliams]

This is not standard for SQL. You can perform that type of where clause by using LIKE instead of =.

As for your problem, try hard coding the expression
....WHERE title='asst mgr'
to see if that returns the correct recordset. If it does, then there may be a problem with your variables. I cannot see anything wrong with the line of code.

Simon