In clause db2 c#

string[] tags = new string[] { "ruby", "rails", "scruffy", "rubyonrails" };
const string cmdText = "select * from tags where '|' + @tags + '|' like '%|' + Name + '|%'";

using (SqlCommand cmd = new SqlCommand(cmdText)) {
   cmd.Parameters.AddWithValue("@tags", string.Join("|", tags);
}

Source: stackoverflow.com

Similar codes

1 vote186 views1 answer
Loop over enum values
C#
0 vote185 views3 answers
How to find all role in mysql
C#
0 vote205 views1 answer
Font dialog c# code
C#
-1 vote182 views1 answer
Instantiate date time variable C#
C#
1 vote194 views1 answer
Take screenshot in c#
C#
4 votes216 views1 answer
C# minimize form
C#
0 vote252 views1 answer
Get web api relative path
C#
1 vote273 views1 answer
Remove repeated items in a list unity
C#Unity
0 vote185 views1 answer
Csharp test for null
C#
0 vote233 views1 answer
Turn list of string to csv c#
C#