Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL or Code for making a series Uniform
Message
From
24/08/2013 03:17:36
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
SQL or Code for making a series Uniform
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01581255
Message ID:
01581255
Views:
53
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
Next
Reply
Map
View

Click here to load this message in the networking platform