Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
LIKE() and LIKE operator
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
LIKE() and LIKE operator
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01061096
Message ID:
01061096
Views:
51
Hi everybody,

These two selects produce different results in VFP9:
SELECT * FROM phones WHERE cArea_Code+cExchange+cLast_four like '???6948400'
SELECT * FROM phones WHERE LIKE('???6948400',cArea_Code+cExchange+cLast_four)
First doesn't return records. The second returns 2 records.
-------------------
It's because LIKE operator uses __ instead of ?.
If it's not broken, fix it until it is.


My Blog
Next
Reply
Map
View

Click here to load this message in the networking platform