LIKE in Query1->SQL->Add ??


2007-05-24 07:01:55 PM
cppbuilder37
Hello All,
What the correct syntax for such Query?
Edit1->Text contains the variable and
Query1->SQL->Add("Select * from CUSTOMER");
Query1->SQL->Add(" Where NAME LIKE '%'");
Query1->SQL->Add(Edit1->Text);
Query1->SQL->Add('%');
in ISQL its
Select * from CUSTOMER Where NAME LIKE '%Asso%'