SQL

I'm building a search page using dreamweaver Ultradev, and it needs an SQL query string to search the database. My problem is this.

The current query string

Code:

---

Select from Search where sHeader like '%Header&'

---

only returns results which exactly match the query. How do I return results which include the query?

THX

I show u my handmade script, i dont know Dreamwaver Ultra Dev, sorry


here the source:




<%
SET Conn = Server.CreateObject("ADODB.Connection")
Conn.open "DSN=kunden"
%>


<%
SET RS = Conn.Execute("SELECT * FROM kunden ORDER BY Name")
SET RS1 = Conn.Execute("SELECT COUNT(ID) FROM kunden")
%>


'to show the first cell:

<%=RS(0)%>

THX, I'll try that later!