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 vote281 views1 answer
Degree between two points latitude longitude c#
C#
3 votes292 views2 answers
How to freeze x and y position in rb2d with code unity
C#
0 vote301 views1 answer
C# new form
C#
4 votes278 views1 answer
Deactivate a gameobject unity
C#
0 vote292 views1 answer
C# show text in another form
C#
0 vote283 views1 answer
Asp net route attribute vs httpget
C#
0 vote343 views1 answer
Lightbox
C#
3 votes322 views1 answer
Unity know when mouse on ui
C#Unity
-1 vote282 views1 answer
C# bootstrap checkbox
C#
3 votes287 views3 answers
C# retrieve files in folder
C#