SQL IN Keyword

HCL Domino Domino Forum
1

Dear All,

Do you know how can I pass the string variable after the IN Keyword of the sql statement below?

I use Lotus Script.

VAR1 = “A,B,C,D”

SELECT * FROM TABLE1

WHERE FIELD1 IN()

I would appreciate it if you could send an example.

2

Subject: SQL IN Keyword

VAR1 = “‘A’,‘B’,‘C’,‘D’”

“SELECT * FROM TABLE1 WHERE FIELD1 IN(” & VAR1 &“)”

3

Subject: RE: SQL IN Keyword

Thanks a lot!