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 Chriss Miller 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. bubbisthedog

    WHERE *field* = '%/%'...

    Thanks, Zathras! Can't believe I forgot about using "LIKE." I really appreciate the help! Regards, bubbis
  2. bubbisthedog

    WHERE *field* = '%/%'...

    Hello, all. Great forum. I'm querying a DB2 table, trying to filter records according to whether or not the, let's say, 'field' value, contains a forward slash (/). I've tried WHERE *field* = '%\/\%' using the backslash (\) to escape the (/) to no avail (records returned are 0). Could...
  3. bubbisthedog

    Calculating Percent of Total...

    Thank you for your help, Dieter! Regards, bubbis
  4. bubbisthedog

    Calculating Percent of Total...

    Hello, all. I'd like the values in ColB to reflect the ColA values divided by the summation of the values in ColA: ColA | ColB 3 | 3/21 5 | 5/21 6 | 6/21 7 | 7/21 I can't figure this one out, and I haven't had any luck finding a solution by searching the Web...
  5. bubbisthedog

    GROUP BY, Two Tables: One Unique, One Not...

    PH, That's friggin' amazing how fast you did that. I've constructed nearly identical derivatives of your statement trying to get it to work, but was apparently missing the AND part. You've helped me a great deal, PH. Thank you very much for your kindness and unbelievable response time...
  6. bubbisthedog

    GROUP BY, Two Tables: One Unique, One Not...

    Hello, all. First post. Following are my table structures ("*" indicates primary keys): TA: EM_ID*, FNAME, LNAME (unique entries) TB: EM_ID, DP_ID, SDATE (not unique entries) TC: DP_ID*, DESC (unique entries) As you can see, TB is my intermediate table, and can include...

Part and Inventory Search

Back
Top