Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Options for avoiding SET FILTER
Message
From
01/02/2000 17:05:22
Michael Dougherty
Progressive Business Publications
Malvern, Pennsylvania, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00325835
Message ID:
00325838
Views:
23
>select * from q:\qa\qdms2000\qdms!document where l_cSearchtext $ title into cursor temp

I know it might seem obvious/trivial but...

WHERE alltrim(upper(l_cSeachtext))$allt(upper(l_cSearchtext))
would cover mixed cases of text. (also, the use of the IN clause might be more effective, but i've never used it - only read about it here on UT)

also for the users' sake:
ORDER by title
Previous
Reply
Map
View

Click here to load this message in the networking platform