Using Wildcards inside TQuerys?!?

[bside]

Hi!
Does anybody knows how to use wildcards inside TQuery statements? I've used '..' but is not running.

I tried to use them in Database Explorer and '..' is running correctly, why?

Thank's
Dani

 

[StevenK]

It may depend on the database you're running the TQuery SQL against but I think that the wildcard '%' should work.
Hope this helps.
Steve

 

[bside]

Hi StevenK,

I use the default Paradox tables. The wildcard '%' doesnt run, neither '@',...

In my previous tip there was a mistake, Database Desktop the wildcard '..' runs perfectly, but in Database Explorer non of the different wildcards run!

Thanks,
Dani.

 

[StevenK]

Are you using the 'LIKE' clause ?
i.e.
SELECT * FROM Table1
WHERE FieldName LIKE 'C%'
Is this where the issue lies ?
Steve

 

[bside]

Yes! That WAS it. The Like expresion does not run equaly in Database Desktop!

I was using "=" instead of Like...

Ok, thanks, now it's running.

Dani.