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 vote141 views1 answer
Get client ip address c#
C#
0 vote177 views1 answer
Unity occulision for hide something
C#Unity
0 vote129 views1 answer
Sharepoint c# get list item query by lookup
C#
0 vote156 views1 answer
How to resize a panel unity
C#Unity
0 vote134 views1 answer
What does focusbale do in listview WPF
C#
2 votes127 views1 answer
Set object to random color unity
C#
21 votes132 views2 answers
Unity get distance between two objects
C#
1 vote165 views1 answer
Check if two linked lists merge. If so, where?
C#
0 vote135 views1 answer
Get parent name unity for inspector
C#
3 votes165 views3 answers
C vs c++ vs c#
C#