(resolvido) sql where ..

[1980coelho]

exemplo:

strSQL = " SELECT *"

strSQL = strSQL & " FROM tblList"

strSQL = strSQL & " WHERE name LIKE '%" & Replace(strSearch, "'", "''") & "%'"

strSQL = strSQL & " ORDER BY date DESC"

Set rs = adoCon.Execute(strSQL)

como faco para ele procurar o WHERE em mais de dois lugares se coloco:

strSQL = strSQL & " WHERE name AND date AND subname AND location LIKE '%" & Replace(strSearch, "'", "''") & "%'"

não rola ele so me pega os dois primeiros, como fazer para pegar mais de dois lugares?

RESOLUCAO:

strSQL = " SELECT *"

strSQL = strSQL & " FROM tblList"

strSQL = strSQL & " WHERE name LIKE '%" & Replace(strSearch, "'", "''") & "%'"

strSQL = strSQL & " Or aka LIKE '%" & Replace(strSearch, "'", "''") & "%'"

strSQL = strSQL & " Or director LIKE '%" & Replace(strSearch, "'", "''") & "%'"

strSQL = strSQL & " Or actors LIKE '%" & Replace(strSearch, "'", "''") & "%'"

strSQL = strSQL & " Or date LIKE '%" & Replace(strSearch, "'", "''") & "%'"

strSQL = strSQL & " ORDER BY date DESC"

Set rs = adoCon.Execute(strSQL)

---

Editado Fevereiro 19, 2013 por 1980coelho