Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT command
Message
 
À
17/04/2000 10:47:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
00360123
Message ID:
00360403
Vues:
17
>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"
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform