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

-2 votes286 views1 answer
Random position unity 2d
C#Unity
-1 vote175 views3 answers
How to use var in c#
C#
0 vote201 views1 answer
Check if element in hashset c#
C#
0 vote181 views1 answer
Set the page that FormsAuthentication.RedirectFromLoginPage redirects to
C#
0 vote184 views1 answer
C# split on multiple characters
C#
0 vote210 views1 answer
.net disable show exception
C#
1 vote178 views1 answer
Cannot convert string to generic type c#
C#
3 votes202 views2 answers
Unity Make a 2D object look at the mouse position
C#
6 votes284 views2 answers
Left moust click unity
C#
1 vote180 views1 answer
Iterate through xpdictionary devexpress
C#