Hello everyone.

First of all, thanks everyone who answered my first doubt here.

I got one more. That's still about SQL script. But now I just wanna know which syntax I must use to run a script.

In BDE (component TQuery), I used to run this script

' Select * from TABLE where ("FIELD" like "%'+ edit1.text + '%") '

I used this when i searched a substring (edit1.text) on table TABLE and on field FIELD, but components IB_Query and IBOQuery dont accept the operator "%". Is there any other operator I can use instead to do this query, or another way to do the query?

Tks.