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

4 votes185 views1 answer
C# create DataTable
C#
0 vote175 views1 answer
C# restore form
C#
1 vote155 views1 answer
How to split and get last index values in c#
C#
174 votes533 views6 answers
C# foreach
C#
26 votes198 views3 answers
Print in c# unity
C#Unity
0 vote179 views1 answer
Mouselook script unity
C#
0 vote173 views1 answer
Check the request comes from which operating system used by user in asp net core
C#
6 votes152 views3 answers
How add script to html in jquery
C#
0 vote164 views1 answer
How to add to a list only items that are not already in the list c#
C#
0 vote160 views1 answer
If char is upper csharp
C#