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

94 votes270 views6 answers
How to convert string to int in c#
C#
3 votes246 views5 answers
Justin bieber
C#
3 votes284 views3 answers
Delegate unity
C#Unity
3 votes295 views2 answers
C# inline array initialization
C#
0 vote257 views1 answer
Save file dialog filter c#
C#
0 vote243 views1 answer
Read all lines split C#
C#
0 vote255 views1 answer
Vb.net windows version check
C#
1 vote317 views1 answer
Unity c# set list to set active true
C#Unity
0 vote259 views1 answer
Wpf binding to static property in code behind
C#
10 votes280 views10 answers
FORTNITe
C#