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

0 vote356 views1 answer
Unity vector3 to array
C#Unity
-1 vote335 views1 answer
Change true to false unity
C#
6 votes357 views1 answer
C# date
C#
0 vote398 views1 answer
Unity how to reorder a list
C#Unity
0 vote379 views1 answer
Asp.net core mvc not triggering client side validation
C#
0 vote334 views1 answer
Prime number Upto n
C#
5 votes341 views2 answers
Unity or
C#
0 vote336 views1 answer
C# substring reverse
C#
3 votes395 views1 answer
Unity desactivate collider
C#Unity
2 votes356 views1 answer
How to set progress openedge driver name for odbc connection c#
C#