try with this,



"where jeprodno.deptno = '" & session("strdeptno") & "' AND " & session

("product") & " LIKE '%jeprodno.prodno%' " & _





in which i assume you have two fields named

jeprodno.deptno and session ("product").



But i think that the query you need is





"where jeprodno.deptno = '" & session("strdeptno") & "' AND jeprodno.deptno

LIKE '%" & session

("product") & %'"



bye







-----Messaggio originale-----

Da: jamesbkim@h... [mailto:jamesbkim@h...]

Inviato: mercoledì 19 dicembre 2001 0.42

A: ASP Databases

Oggetto: [asp_databases] RE: Search feature that matches anywhere in a

field





Hi Owen,



I used that method but it returned no record matches.

Here is the code that I used.



"where jeprodno.deptno = '" & session("strdeptno") & "' AND '" & session

("product") & "' LIKE '%jeprodno.prodno%' " & _



What's wrong with my coding?



James






$subst('Email.Unsub').