Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL or Code for making a series Uniform
Message
De
24/08/2013 03:17:36
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
SQL or Code for making a series Uniform
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01581255
Message ID:
01581255
Vues:
52
I am having the following data in a filed posC N (8,2). The Highest among it is 561 and occurs four times in the entire records. The next higher is 549. I need to have difference of 10 points in each next lower digit. So in place of 549 in need 551. Similarly , next higher is 545 that occurs two times , I need 541 for both 545 and like wise

How it will be done ?
23
23
179
293
389
536
23
230
338
446
561
23
222
338
446
561
23
149
23
68
23
23
183
223
341
381
386
431
465
471
501
545
551
23
195
243
375
460
539
23
195
243
375
460
539
23
149
23
68
23
23
293
388
512
543
549
23
292
386
532
23
532
23
23
162
223
341
381
386
431
465
471
501
545
551
23
168
241
375
460
539
23
171
241
375
460
539
23
168
241
375
460
539
Regards
Harsh
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform