Comments by RajeshKumar Sugumar (Top 6 by date)

*2 means ProcessID ends with 2, 2* means ProcessID starts with 2, *2* means ProcessID Contains 2. If i used Contains for all these means the excepted output will me failed.

If the User Except the ProcessID starts with 2 means , the Outcome result will be "Contains" ProcessID.

Sample Data
PROCESSID
21
11
12
222
245
357
572

if the User Search for 2* means , the outcome result will be "21,222,245". If i used "contains" means the outcome result will be "21,12,222,245,572". So this is Wrong Output.

ok. But i use this query for my search page so the user can search the values in any way (2*,*2,*2*) . Here i want to do all this operation in same Where condition itself . This is the problem which i am facing here.

its "2%" only

This is Query i am using in SqlServer.

Select * from PROCESS Where CAST(ProcessID as varchar) Like '2*'

The Linq Query which i tried is

var people = (from t in sample.PROCESSes
where SqlMethods.Like(SqlFunctions.StringConvert((double)t.ProcessID), (check.Replace("*", "%"))) == true
select t).ToList();

AND

var query1 = from c in sample.PROCESSes
where SqlFunctions.CharIndex(SqlFunctions.StringConvert((double)c.ProcessID), check) > 0
select c;
these are ways but i not getting the output ......