Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Ignore case in VFP SQL statement
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01525277
Message ID:
01525286
Views:
73
>>Hello,
>>
>>was there not a SET() command to ignore the case in SQL statments, so I don't need to
>>
>>WHERE UPPER(Lastname) = "TEST"
>>
>>In a query on a VFP table?
>
>
>SET COLLATE to "GENERAL"
>
>Be aware of index collation sequence for rushmore optimization.

Hmmm. From VFP Help
SET COLLATE to "GENERAL" - Only for English, French, German, Modern Spanish, Portuguese, and other Western European languages :o(((

Who are the Western European languages? ;o)))
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform