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 votes262 views2 answers
Asp.net core identity get user id
C#
0 vote258 views1 answer
Msbuild publish to folder command line .net
C#
0 vote255 views1 answer
C# scrape html document
C#
14 votes260 views1 answer
Unity string split
C#
0 vote262 views1 answer
C# loop through repeater items
C#
0 vote249 views1 answer
Beard styles without mustache Intitle:work with me
C#
5 votes299 views1 answer
C# write variable in string
C#
1 vote253 views1 answer
Teleport in vue
C#
1 vote257 views1 answer
Newtonsoft create dynamic object
C#
1 vote310 views1 answer
UnityEngine.Transform.get_position () (at <a0ef933b1aa54b668801ea864e4204fe>:0) Gamekit3D.MeleeWeapon.BeginAttack (System.Boolean thowingAttack)
C#Unity