Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL pulls up records with blanks
Message
From
10/04/2001 13:07:43
Nicholas Mason
London, United Kingdom
 
 
To
10/04/2001 12:23:11
Randy Waldman
Hoffer Companies
Houston, Texas, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: SQL pulls up records with blanks
Miscellaneous
Thread ID:
00494057
Message ID:
00494077
Views:
17
Hi Randy

if set ANSI is OFF the comparison ends at the end of the shorter string so your empty key is equal to your query value. You could use == or SET ANSI ON to get an exact comparison.

Nick Mason
Previous
Reply
Map
View

Click here to load this message in the networking platform