Hi...
you can use this code :
strSQL = "SELECT ID, Title, SYMPTOM, Keywords, Sum, Resolution, Cause, Component, FAQDate, PUBLICFAQ FROM FAQ WHERE "
'Build the sql string
For x = LBound(searchArray) To UBound(searchArray)
If x > LBound(searchArray) Then
strSQL = strSQL & " AND "
End If...