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 votes142 views2 answers
Prime Number in C#
C#
2 votes144 views3 answers
Difference between while and do while in c#
C#
0 vote142 views1 answer
Valid URL check in c#
C#
0 vote137 views1 answer
If equal statement c#
C#
0 vote177 views1 answer
Get execution directory c#
C#
0 vote142 views1 answer
Check dotnet version command line
C#
3 votes183 views2 answers
Unity set cursor position
C#
0 vote211 views1 answer
Unity ignore collision between two objects
C#Unity
0 vote136 views1 answer
If input.get touch
C#
0 vote93 views1 answer
How to make a capsule walk in unity
C#