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

0 vote305 views1 answer
Custom Encrypted String Type
C#
13 votes318 views3 answers
How to use console in c#
C#
2 votes329 views1 answer
How to run a function as administrator in c#
C#
0 vote311 views1 answer
Irrrtate throught an matrix c#
C#
47 votes337 views5 answers
Remove last character from string c#
C#
0 vote346 views2 answers
Can a dictionary type use get set c#
C#
0 vote341 views2 answers
Cassandra Keyspaces repository .net
C#
0 vote349 views1 answer
Play sound in sequence unity
C#Unity
0 vote311 views1 answer
Unity c# public all codes
C#
30 votes296 views2 answers
C# how to initialize an array
C#