Search results for query: *

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

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...

Thank you for your help, Dieter! Regards, bubbis

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...

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...

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...