General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
VFP select not same as SQL Select
Environment versions
Network:
Windows 2000 Server
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only