Syntax of a Query Question

[chrispl]

In my .asp file I can display a value with the following code .....

<%Response.Write(session("uid"))%> (Displays Chris on the screen)

What I want to do now is amend my query to be something like this .....

fp_sQry="SELECT * FROM Teams WHERE (ManagerCode = " & Response.Write(session("uid"))

of course it doesn't work. It displays the text 'Chris' instead of including it in the search text.

What do I need to do to correct it?

Many Thanks, Chris.