Like loading the zeros in SQL

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Like loading the zeros in SQL

Message

05/05/2006 17:40:40

Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia

05/05/2006 17:11:39

Vladimir Zografski
Microcomplex Ltd
Sofia, Bulgarie

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Re: Like loading the zeros in SQL

Versions des environnements

Visual FoxPro:

VFP 9 SP1

OS:

Windows XP

Network:

Windows 2000 Server

Database:

MS SQL Server

Divers

Thread ID:

01119748

Message ID:

01119790

Vues:

>Try this
>

>*** Version VFP9 SP1
>CLEAR
>m.numest = 45
>? RIGHT('0000'+ALLTRIM(STR(m.numest)),4) &&& result 0045
>? PADL(m.numest,4,"0")                   &&& result 0045
>

And let's not forget

?transform(m.numest, "@L 9999")

back to same old
the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.

Répondre

Fil

Voir

Click here to load this message in the networking platform