Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SELECT command
Message
 
To
17/04/2000 10:47:58
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00360123
Message ID:
00360403
Views:
18
>You're right Jim, maybe I was confuse too.
>See the 2 or 3 first digits are the one I'm interest on but I don't see a way to retrieve only those in a field of 7 digits when in reality I need to say '=' cause I don't want anything else.
>I think I will need another field in the table.
>So I think I gonna go that route

Edgar,

No you don't need another field, hjust SET ANSI OFF and SET EXACT OFF and then;

SELECT Whatever FROM Whatever WHERE Field = "01"

will find all records where the field BEGINS with "01"
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform