Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP select not same as SQL Select
Message
From
18/10/2005 23:03:18
Joel Hokanson
Services Integration Group
Bellaire, Texas, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
VFP select not same as SQL Select
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 2000 SP4
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01060137
Message ID:
01060137
Views:
58
select * from cities where city='HOUSTON' in VFP produces 4 records

city Houston, HOUSTON, HOUSTON HEIGHTS , HOUSTON AIRPORT. Which is right


select * from cities where city='HOUSTON' in MS SQL 2000 produces 2 records

city Houston, HOUSTON

Naturally I can set exact on in VFP,
but I would prefer to know how to say "city Starts with HOUSTON" in SQL

Is that feasible?
Next
Reply
Map
View

Click here to load this message in the networking platform