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 vote121 views1 answer
Check if panel has controler c#
C#
0 vote113 views1 answer
Button Previous for picturebox c#
C#
0 vote106 views1 answer
C# async to sync
C#
0 vote119 views1 answer
Two lowest positive numbers given an array of minimum
C#
1 vote115 views1 answer
C# + max char frequency in string
C#
0 vote140 views1 answer
Unity exenerate
C#
1 vote164 views1 answer
Get all devices in game unity
C#Unity
19 votes166 views2 answers
Unity set text value
C#Unity
0 vote136 views1 answer
Call a .NET assembly from C or C++
C#
1 vote110 views1 answer
Select a object from list based on a value csharp
C#