Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT command
Message
De
16/04/2000 15:31:36
Mike Helland
MonadPad.com
Seattle, Washington, États-Unis
 
 
À
16/04/2000 11:50:21
Edgar Del Gesso
Consultant
Riverside, Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Re: SELECT command
Divers
Thread ID:
00360123
Message ID:
00360154
Vues:
10
>Now the problem with this is it will retrieve '011' or '0122' or wherever is after that. I don't want that. I only want the value of '01'
>What function can I use to do this? Or how can I say that in my SELECT?

I dunno how SQL Server works really, but if its anything like FoxPro, try padding the property with spaces:

padr(Thisform.MyProperty, 7)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform