[thelist] Wordsearch in ASP/Access

[David.Cantrell at Gunter.AF.mil]

>For example, if someone types in the word
>"Linux" I want every entry with the word Linux in it to be returned.

If everything is going into a database, then you can just run a wildcard
("%") query:

	dim sSql   : sSql   = "select * from table"
	dim sTerm  : sTerm  = Request.Querystring( "searchterm" )
	If Len( Trim( sTerm ) ) > 0 then
		sSql = sSql & " where fieldname like '%" & sTerm & "%'"
	End If
	'...execute sSql, get recordset, convert to xml, pipe through xsl...
:)

HTH,
-dave