Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Finding Mismatches
Message
 
 
To
17/09/2001 17:03:46
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00557515
Message ID:
00557524
Views:
10
>When I use this code I get 119 records:
>! AllT(myBales1.dwgrev) $ AllT(pchange.dwgrev)
>
>When I use this code I get 102 records:
>AllT(myBales1.dwgrev) <> AllT(pchange.dwgrev)
>
>Which is the correct way?

The second gives you records, which are not completely identical. The first will give you more records, because
Field1 = "Steven"
Field2 = "Steven Duke"
! alltrim(Field1) $ alltrim(Field2) will return .f.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform