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 dencom 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: mkjjj
  • Content: Threads
  • Order by date
  1. mkjjj

    Search for invalid question marks in text

    We copy and paste text from Word into a database. What happens when cutting and pasting from Word, it replaces an apostrophe with a question mark so for example "you're" becomes "you?re" in the database. Is there a way to search for all question marks that are not correct in Crystal since...
  2. mkjjj

    Command Line Question

    I have a text file with numerous update statements. The text file is running and it shows the following after it has run each update statement. Query OK; 1 row affected (0.47 sec) Rows matched: 1 Changed: 1 Warnings: 0 Is there a way on the command line to show which update statement it has...
  3. mkjjj

    delete records based on a minimum value per group

    rows id term 1 932 1 934 2 992 2 1008 3 944 3 1014 I want to delete any ids if their first term was less than 992 so in the example above, only the 2 rows for id 2 would remain in the database, since id 2 first term is 992. I'm thinking that I would need a group by and having...

Part and Inventory Search

Back
Top