>All
>
>I know there is a way to insert a list of values into the IN() clause of a DBC View... but I can't seem to make it work.
>
>I've tried
>
>lcMyListOfVals=[val1','val2','val3]
>
>and
>
>lcMyListOfVals=[val1","val2","val3]
>
>but they don't work. I was fairly sure that the double quote version should work...
>
>Can someone please point me in the right direction?
>
>Thanks
>
>JR
The syntax is:
WHERE TableName.FieldName IN ("BOB","TOM","TED")
Is that what you are wanting?
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope