Allow the use of AND instead of hard coded OR for comma deliminated fields

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Attempt to write query to select all fields where something is not equal to 
a predefined list

What is the expected output? What do you see instead?
Failure since OR is hard coded.

What version of the product are you using? On what operating system?  With
what Salesforce.com edition?

Winter 11 Release
XP
Professional

Please provide any additional information below.

In the {{{ general case }}} I've modified the values declaration/assignment to 
the following:
{{{
Dim values As Variant
Dim logic_opr As String: logic_opr = "or"
If Mid(vlue, 1, 1) = "&" Then
    logic_opr = "and"
    vlu = Mid(vlu, 2)
End If
values = Split(vlu, ",")
}}}
And then modified the statement
{{{ If Len(clause) > 0 Then clause = clause & " or " }}}
to be
{{{ If Len(clause) > 0 Then clause = clause & " " & logic_opr & " " }}}

Original issue reported on code.google.com by tre...@gmail.com on 21 Jan 2011 at 11:39