Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why are these SQL statements different?
Message
From
21/04/2000 12:39:54
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00362213
Message ID:
00362272
Views:
17
If you read in Help, it says:

"The == operator can be used when an exact comparison of character data is needed. If two character expressions are compared with the == operator, the expressions on both sides of the == operator must contain exactly the same characters, including blanks, to be considered equal. The SET EXACT setting is ignored when character strings are compared using ==."


>Craig, Tamar and Cindy,
>
>? Set('Collate')=Machine
>? Set('exact')=Off
>? Set('ansi')=Off
>? Set('deleted')=On
>
>Should exact be on since I'm using ==?
>
>Thanks for the help,
>Doug
Previous
Reply
Map
View

Click here to load this message in the networking platform