Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
dbo.Person table:
id name
1 Grant
2 Jim
3 Bob
--------------------------------------------------------------------------------------
set a = 1,2;
names:
load id,name;
SQL select id,name
FROM dbo.Person WHERE id IN ($(a)); // output: 1 Grant ; 2 Jim
set a = Grant, Jim;
names:
load id,name;
SQL select id,name
FROM dbo.Person WHERE name IN ($(a)); // failed
Try this,
set a = 'Grant','Jim';
names:
load id,name;
SQL select id,name
FROM dbo.Person WHERE name IN ($(a));
Try this,
set a = 'Grant','Jim';
names:
load id,name;
SQL select id,name
FROM dbo.Person WHERE name IN ($(a));
Perfect, it works now, thanks so much.