hi <BR><BR>does anyone know how to add a free text query on an asp page??<BR><BR>for example this query<BR><BR>Set rs=myConn.Execute("SELECT * FROM tblStaff WHERE Surname=&#039;" & sName & " &#039;;")<BR><BR>is used with a text box where sName= Request.Form("srn")<BR><BR>However this only brings results of whole names only. how can this query be amended so partial searches can be formed <BR><BR>eg search names beginning with &#039;R&#039;?<BR><BR>thanx<BR><BR>choti<BR>