darma teja

darma teja

  • NA
  • 496
  • 330.8k

array in sql-where

Dec 16 2013 5:36 AM
Hi,

I have a string array.
Example:

string[] test =new string[3] {"abc,def", "ghy,spd", "xyz,uni"};

How can put this array in sql where clause:

My final output query should like this:

Select *
from tableName
where id in ('abc', '
def', 'ghy', 'spd', 'xyz', 'uni');

Thanks,
Darma

Answers (4)