Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Odd SELECT result
Message
From
27/09/2002 11:54:41
Sergey Berezniker
New York, United States
 
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Re: Odd SELECT result
Miscellaneous
Thread ID:
00705231
Message ID:
00705283
Views:
9
This message has been marked as a message which has helped to the initial question of the thread.
>In the Help it says
>"" = "ab"  is no match
>Is this not my case (comparing an empty string to something)?

It's not true for queries because comparison in queries is controlled by SET ANSI not SET EXACT. So in query
"" = "ab" 
*is the same as 
"ab" = ""
and both return True if SET ANSI is OFF (default). See SET ANSI topic in the help for details.
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform