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 vote222 views5 answers
Var c#
C#
0 vote153 views1 answer
C# int cast error
C#
16 votes133 views1 answer
For loop on enum c#
C#
2 votes271 views1 answer
Simple reset transform.rotation c#
C#
1 vote129 views2 answers
Lerp c#
C#
0 vote170 views1 answer
Multidimensional meaning
C#
2 votes174 views2 answers
C# regex number only
C#
0 vote165 views1 answer
C# close program
C#
1 vote161 views1 answer
Audiomixer get float
C#
9 votes131 views2 answers
Cast int as enum c# microsoft
C#