Board index » delphi » SQL Local Wildcards

SQL Local Wildcards

I have tried using the @ and .. wildcards in my dBase SQL queries to no
avail.  does anyone have any examples on how these work?  Do they work
on Paradox only?  Please email me at i...@rascon.com

 

Re:SQL Local Wildcards


Quote
Ruben Rascon R. wrote:

> I have tried using the @ and .. wildcards in my dBase SQL queries to no
> avail.  does anyone have any examples on how these work?  Do they work
> on Paradox only?  Please email me at i...@rascon.com

Did you try using the 'Like' keyword ?
For example: Select * from sometable where state like "New%"
This will give me the list of states that begins with "New" ie. New
York, New Jersey ...so on..

Peter

Other Threads