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

40 votes336 views5 answers
C# foreach dictionary
C#
28 votes396 views3 answers
Delay in unity
C#Unity
0 vote333 views1 answer
Remove loading bars devexpress on callback
C#
0 vote338 views1 answer
Unity get camera
C#
1 vote350 views6 answers
Laravel collect
C#
1 vote340 views1 answer
Dapper delete where in list
C#
9 votes372 views1 answer
Unity delete specific text in a string
C#Unity
0 vote333 views1 answer
How to make console wait c#
C#
0 vote330 views1 answer
How to uncheck a radio button in c#
C#
0 vote403 views1 answer
CamelCase and snakeCase
C#