Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL into one and 'A' before 0
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
SQL into one and 'A' before 0
Miscellaneous
Thread ID:
00794037
Message ID:
00794037
Views:
44
Clean up this code---
  Select contact, eligarea, groupnum, groupname, IIF(ASC(contact)>64, ASC(contact)-48,ASC(contact)) as contactord from modicomm ;
         WHERE NOT DELETED() ORDER BY contactord INTO CURSOR TempC
  SELECT contact, eligarea, groupnum, groupname FROM TempC INTO CURSOR Temp
  Select Temp
  Copy to C:\Temp\vsamnew.txt Type SDF
The reason for the IF in the SQL is to force 'contact' that begin with a letter to be before contacts that begin with a number.

This mess works, but, I would like it cleaned!
Edgar L. Bolton, B.S. B.B.A.
Next
Reply
Map
View

Click here to load this message in the networking platform