Søgning

Noget i retning af:

strKeyword = Request.Form("Keyword")
strArrKeyword = split(strKeyword,"+")
bolFirst = true

strSQL = "SELECT * FROM tabel"

for x = 0 to UBound(strArrKeyword)

  if bolFirst Then
    strSQL = strSQL & " WHERE kolonnenavn like '"&strArrKeyWord(x)&"'"
    bolFirst = false
  else
    strSQL = strSQL & " AND kolonnenavn like '"&strArrKeyWord(x)&"'"
  end if
next

Response.Write(strSQL)