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!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. 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.
  2. pwright

    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"
  3. pwright

    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) + " " +...

Part and Inventory Search

Back
Top