🚀 go-pugleaf

Hi,
maybe too late, just to let you know that work around is:

Query4->ParamByName("AName")->AsString=Edit1->Text + "%";

for your query:

> SELECT DISTINCT Artist, Album, Release FROM Artist, Album, Track
> WHERE Artist LIKE :AName
> AND Artist.AID = Track.AID
> AND Track.CDID = Album.CDID

> The SQL-statement works with no errors but I have the need to search
> with wildcards in order to for example serch by artist and for rage and
> get Rage Against The Machine in the DBGrid. (I hope you understand what
> I mean)
> The problem is this, I don't know how to use wildcards. In Access97 that
>
> I use for my database, I can use '*rage*' and in other databases they
> use % instead of *. The problem is that it does not work in a Query with
>
> SQL-statement and parameters. I've tried to write '*:AName*', '%:AName%'