Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exact OFF Strrange Behaviour
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Exact OFF Strrange Behaviour
Miscellaneous
Thread ID:
00861443
Message ID:
00861443
Views:
64
I am using SQL Statement which brings more records than I need because it behaves like SET EXACT OFF, here is my statement
SELECT code from items where alltrim(code) >= '140' and alltrim(code) <= '140'
The Result sets contains records for item = '140' and item = '1404'
I even tried to set exact on but with no change.
Any Help on that
Next
Reply
Map
View

Click here to load this message in the networking platform