Re: Research using LIKE in binary field.

Return to index

Author

Message

Sergey Tkachenko

Posted: 10/10/2002 16:48:51

I do not know.

Does it work dor binary fields?

>

> Example:

>

> procedure TForm1.PesquisaClick(Sender: TObject);

> Var

>    Campo : String;

> begin

>    Query1.Close;

>    Query1.SQL.Clear;

>    Campo :=  'TO BE SEARCHED WORD'; //Normal word

>    Begin

>       Query1.SQL.Add('SELECT * ' +

>                      'FROM Principal WHERE ');

>       Query1.SQL.Add(' Conteudo LIKE ''%' + Campo + '%''');  //Conteudo -

> Binary field of one prices of the MSAccess, that is used in the

DBRichView.

>    End;

>    Query1.Open;

> End;

>

> At

> Aleksey

>

>

>

>