USING 'LIKE' In Where Clause

[CrimsonDiva]

Hello,
I'm trying to provide a database search using pattern matching. For instance, a user wants to search for all occurences of the word "access" in my database. I'm having trouble writing the SQL portion of this code. This is what I have now:

SrcTxt = Request.Form("SearchTxt&quot

sql = "SELECT Synopsis, Desc, Answer " & _
"FROM FAQ " & _
"WHERE Synopsis LIKE '" &SrcTxt& "%' " & _
"ORDER BY Synopsis; "

Where "SearchTxt" is the name of the text field in the search. When I run the above code (with the ASP file), it produces no results even though I know that it should produce at least 1 record. PLEASE HELP!!!
[sig][/sig]

 

[Karl Blessing]

maybe it finding all &quot;access%&quot; meaning, unless it starts with access it returns no result, try %thetext% [sig]<p>Karl<br><a href=mailto:kb244@kb244.com>kb244@kb244.com</a><br><a href=

http://kb244.com>

</a><br>Experienced in : C++(both VC++ and Borland),VB1(dos) thru VB6, Delphi 3 pro, HTML, Visual InterDev 6(ASP(WebProgramming/Vbscript)<br>

http://www.brainbench.com/transcript.jsp?pid=629151

[/sig]

 

[NickBulka]

What database are you using? Different databases use different characters for wildcards.

[sig]<p>nick bulka<br><a href=mailto: > </a><br><a href=

http://www.bulka.com>

</a><br>Get your technical books at Bulka's Books<br>

http://www.vstorebooks.com/bulkasbooks

[/sig]