Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
What is better and faster
Message
 
 
To
18/01/2005 18:24:55
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Miscellaneous
Thread ID:
00977833
Message ID:
00978687
Views:
27
>On VFP the LIKE 'expr%' can run with a full index filtering,
>but exists two issues:
>1. on VFP don't exists a escape character,
>then for search a '%' or a '_' the LIKE is useless

The documentation shows an ESCAPE clause for SELECT - SQL.
It doesn't look like there is an ESCAPE for LIKE().
- Andy Rice
San Diego, CA
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform