is there any combination of 'in' and 'like' operator.

Not sure what you mean by single or multiple selections.

When I put the code I posted earlier into a program and run it:

using System;
using System.Text.RegularExpressions;

class Program
{
   static void Main()
   {
    string shape = " 'round', 'pearl', 'oval', 'heart', 'princess' ";
    string temp = Regex.Replace(shape, @"\w+", "%$0%");
    string[] shapes = Regex.Split(temp, ",");
    temp = "shape like" + String.Join(" or shape like", shapes);
    string query = "select * from table1 where " + temp.Trim() + ";";
    Console.WriteLine(query);
   }
}

the output is:

select * from table1 where shape like '%round%' or shape like '%pearl%' or shape
 like '%oval%' or shape like '%heart%' or shape like '%princess%';

which is what I thought you wanted here?

Vulpes Please Help in

http://www.c-sharpcorner.com/Forums/Thread/258515/two-string-in-where-condition-for-one-column.aspx

Thanks

Hello Vulpes,

this work on single selection, when more than two shape are selected its not return any row.

??????????

Sorry, Bhabani, but as someone who's principally a desktop developer, it's not something which is within my areas of expertise.

You just need to do a bit of manipulation to build the query from the raw 'shape' string:

Yes,

But i dont know how many and which shapes are in string.
so how can i check like operator with all them ?