Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL pulls up records with blanks
Message
From
10/04/2001 13:08:48
Cindy Winegarden
Duke University Medical Center
Durham, North Carolina, United States
 
 
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:
00494078
Views:
16
Randy,

Read in Help about SET("Exact"). You can use CustNo == '12345' or ALLTRIM(CustNo) = '12345' to get only those with '12345', and not '123' or whatever.


>An SQL statment such as: SELE * FROM customers WHERE custno = '12345' also pulls up records with an *empty* custno filed. Why?
>Thanks, Randy
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform