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 vote115 views1 answer
How check if variable is send to page or not in laravwel
C#
0 vote113 views1 answer
Converting dens_rank and row_number to linq
C#
0 vote115 views1 answer
Bitter foods examplews
C#
0 vote146 views1 answer
True false when key pressed in c sharp unity
C#Unity
0 vote126 views1 answer
Razor preview
C#
3 votes101 views1 answer
C# public 2d array
C#
0 vote102 views4 answers
How get the user show mvc controller core 3.1
C#
0 vote110 views2 answers
Asp.net core get root url in view
C#
0 vote110 views1 answer
SqldataReader get row count
C#
20 votes115 views4 answers
Generate random string C#
C#