Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by pwright
-
Random Select
Has anyone written sql to select exactly 10% of the records from an existing file. The records must be randomly selected from throughout the file.- pwright
- Thread
- Replies: 2
- Forum: Microsoft: FoxPro
-
Do Case
I am trying to use Do Case to update fields in a very large file. I'm having trouble with the exact structure of the code. i.e. - existing field value = "ARABIC" new value = "A" existing field value = "ASIAN" new value = "B"- pwright
- Thread
- Replies: 2
- Forum: Microsoft: FoxPro
-
string trans
I have a data file of 100k+ records. After concatonating the address into 1 field, some addresses have multiple spaces (3-5) resulting from individual fields in the " parsed" address being blank. here is my code for the concatonate: set address = allt(stno) + " " +...- pwright
- Thread
- Replies: 3
- Forum: Microsoft: FoxPro
