Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL comparison positioning
Message
From
06/01/2000 13:12:24
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
 
To
06/01/2000 11:47:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00313954
Message ID:
00314009
Views:
53
Chas,

Please read about string comparisons in Help under the SET EXACT command.

It says in part:

"String Comparisons

Visual FoxPro has two relational operators that test for equality. The = operator performs a comparison between two values of the same type. This operator is suited for comparing character, numeric, date, and logical data.

However, when you compare character expressions with the = operator, the results might not be exactly what you expect. Character expressions are compared character for character from left to right until one of the expressions isn't equal to the other, or until the end of the expression on the right side of the = operator is reached (SET EXACT OFF), or until the ends of both expressions are reached (SET EXACT ON)."


>
>How would one know he or she has
> to reverse the Field/variable comparisons????????
>
> Thanks, this is a puzzler.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform