🚀 go-pugleaf

you can do so :
ADOQuery->SQL->Text="select * from Table1 where field1 like '%'+ :param1
+'%'";
ADOQuery->Parameters->ParamByName("param1")->Value="test it";
ADOQuery->Open();

The like statement has the jolly chars % and _
% = any string of any length (like the * in the windows or dos file search)
_ = any character, length 1 (like the ? in the windows or dos file search)

Depending on the database you are connecting to, you have to include the
special characters in the parameter or in the way I wrote.

HTH
Ciao
    Formentz

"Daniel Zhou" <langou@gmx.de> ha scritto nel messaggio
news:3c980ae5_2@dnews...
> Hi,
> I want to search a substring in a table. How can I write a select
statement
> to do it?
> For example:
> I want to find all record in Table Content where Content.Field1 include
the
> substring "Test it".
> Is it correct:
>
> Select * from content where "Test it" in field1.
>
> How can I write it in C++ Builder?
>
> ADOQuery -> SQL->ADD("Select * from Content where :field1 in field1");
> ADOQuery->Parameters->ParamByName("field1")->Value= "Test it";
> ADOQuery -> Open();
>
> Please help me?
>
> thanks!
>
> Daniel
>
>