The weight always ends in PT and is always before the UPC.

so for 3 dummy examples:

PTPTPTPTPTPT 5.5PT 1234566

PT PT PTP P T 0.7PT 12345656

PTPTP PPP TTT PTP 4PT 123456

Jacek0,

Thanks for the quick post. Im not having any luck with your script as of yet. I think you have one too many parameters set because it returns 2 separate...

wow! thanks for the answer guys. this solution worked perfectly. i would have never thought of doing this. i still dont quite understand how using the max function is making...

thanks for all your help...much appreciated..

table1:

gid     pid  value     cat

1         5    77        a

1         5    3.2       b

1         5    80        c

table2

gid pid   a    b    c

1    5   null null null

im trying to update table2 and...

i tried using the inner join. still only one of the 3 fields is being updated.

referring to my post before this one, because the join returns 2 rows of...

updating with the 'value' is correct, my mistake if i had mentioned i wanted to update with the 'cat'.

what im finding is this: when i join table1 & table2 together...

yes, much more script. and the ''' worked fine. i was using the print function, but i must have had a brain cramp. i never tried doubling up the quotes.

bless you! the simplest syntax can be the hardest sometimes.

many thanks

ryan