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 vote248 views1 answer
Detecting a right click unity
C#Unity
0 vote227 views1 answer
C# passing function as input delegate
C#
1 vote258 views1 answer
C# for each textbox lines
C#
1 vote218 views2 answers
How to make a game
C#
0 vote210 views1 answer
Linq query to check if record exists
C#
0 vote213 views1 answer
C# list subfolders
C#
0 vote245 views1 answer
Wpf onpropertychanged not working
C#
10 votes230 views2 answers
How to set a color of text in unity 2020 script
C#
2 votes217 views5 answers
Enum c#
C#
16 votes189 views4 answers
C# string replace
C#