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 vote130 views1 answer
For loop string in c#
C#
0 vote111 views1 answer
How to concert a list into strinf splitted by coma c#
C#
0 vote113 views1 answer
Wpf get dynamic resource from code
C#
0 vote126 views1 answer
C# webrtc dll
C#
0 vote146 views1 answer
.Net Core Bundling & minification : .net core The name 'Scripts' does not exist in the current context
C#
3 votes125 views1 answer
Rigidbody2d unfreeze position
C#
0 vote127 views1 answer
Unity camera.main.screentoworldpoint(input.mouseposition) not working
C#Unity
0 vote123 views1 answer
C# webclient submit form
C#
0 vote117 views1 answer
Unpacking c # tuple
C#
2 votes120 views1 answer
C# program that uses array, yield keyword
C#