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

8 votes148 views1 answer
Round to float unity
C#Unity
1 vote119 views1 answer
C# how to output in between 0 - 100 in an int array
C#
0 vote55 views1 answer
Unity insert variable into string
C#
1 vote136 views1 answer
Consecutive numbers c#
C#
1 vote102 views1 answer
How to pause in unity for debug
C#
1 vote138 views1 answer
Create gaps / headers between variables in the unity inspector
C#Unity
0 vote101 views1 answer
How to get the date of the first day and last day of the week c#
C#
14 votes156 views3 answers
String to int c# unity
C#Unity
0 vote102 views2 answers
How to subtract two rows asp ne gridview in asp.net
C#
0 vote99 views1 answer
Xamarin forms CarouselView doesn't swipe items one by one
C#