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 Wanet Telecoms Ltd 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: *

  • Users: nkomokov
  • Content: Threads
  • Order by date
  1. nkomokov

    Filling Table B with certain fields from Table A

    I'm not quite sure how to do this... I have Table A which has 100,000 records but no names and I have Table B which is made up of 30,000 records previously pulled from Table A and manually filled in Name fields, but whoever pulled it forgot to pull the ZipCode field, so now I need to populate...
  2. nkomokov

    moving data to another table and deleting it from original

    I want to move all fields of all records that have a duplicate email address to another table so that I can sort through those at my leisure while still having the previous table without any duplicates for email blasts. I have this code to find duplicate email records, but I'm not sure how to...
  3. nkomokov

    Zip Code Field needs to be an Integer BUT what about leading ZEROES?

    I have a ZipCode field that needs to be an integer for query purposes, but it lops off the leading zeroes on zips like 03421. Is there a way to make it allow leading zeroes other than changing the datatype to char?
  4. nkomokov

    Turn all <NULLS> in a table into blanks?

    I want to change all the NULL values into blanks to ease my manual editing of duplicates. How?
  5. nkomokov

    Easily display all column results when executing a query?

    Is there a quick way to get the results pane to display all columns in a table instead of manually listing them off in the query?
  6. nkomokov

    Finding Duplicates to Manually Alter and Delete

    I have a very messy database that I'm trying to sort through. I need to find the records that have duplicates, manually ensure that one record has ALL of the information, then manually delete the extras. So say for example, I want to find ALL the records with duplicate email addresses and view...
  7. nkomokov

    deleting specific data from one column in a table

    I'm trying to delete all zip code data that doesn't conform to the USA standard 5 digit zip in column ZipCode. Currently the column contains zips and postal codes in a wide variety of formats... 97217 97217-1811 V0N 1B0 ER34B7R88 97217, OR Ideally, I would like to delete all the zip codes...

Part and Inventory Search

Back
Top