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

7 votes300 views2 answers
: ? operator in c#
C#
29 votes277 views3 answers
C# get bytes from string
C#
2 votes277 views1 answer
C# display attribute date
C#
0 vote327 views1 answer
Nuget package TSETMC guide
C#
0 vote277 views1 answer
Httpcontext in .net standard
C#
0 vote269 views1 answer
Difference between awake and start unity
C#
1 vote268 views1 answer
C# multiple inheritance
C#
1 vote284 views1 answer
Look rotation only on y axis in unity
C#
0 vote309 views1 answer
Count the Number of Duplicate Characters
C#
0 vote270 views1 answer
How to determine whether Task.Run is completed within a loop in c#
C#