Given the following SQLcommend Text as sample:

 "select * from customers where cust_id like '%" + textbox1.text.tostring.trim +"%'"

What's the VB.NET/C# equivalent for it as below:

Dim CustID As String

if CustID ??? textbox1.text.tostring.trim

??? is the code you fill in for the T-SQL "like".

Thanks.

 you can do

string.Contains(Valuetosearch)

CustID.ToLower().Contains(textbox1.text.ToLower())  ; // I added the to lower to make sure that both are of the same case

I Guess, Its same in VB.NET
Contains is both in VB.NET / C#

 CustID.IndexOf(textbox1.text.tostring.trim()) != -1

 Hi BNDIT,

You could try:

//If has any part of textbox1.text returns true
if(CustID.Contains(textbox1.text.ToString())
{
   //Do Something
}

 You can also check here http://msdn.microsoft.com/en-us/library/fbh501kz(VS.80).aspx for string comparison methods.

Hope this helps,

Scott